By using Access editor, or by setting AllowUpdate property of DataGrid to True I can edit any field. I can also erase the whole content of a field so it stays blank. My question is: is there a way to erase a field that holds Date data type, from the code? I tried this:
dbObject.Recordset.Field(1) = CDate(vbNull)
but DataGrid displays a field that says "12/31/1899". My goal is make the field blank. I would appreciate any information.
