How to update the Date or other type field in Access db with Null value? After that I'd like to see empty cell, the same as it was before something was entered in that field.
Thank you
Vlad
Printable View
How to update the Date or other type field in Access db with Null value? After that I'd like to see empty cell, the same as it was before something was entered in that field.
Thank you
Vlad
did you try
yourRecordSetVariable.Edit
yourRecordSetVariable.fields("yourfield").value = null
yourRecordSetVariable.Update
?
I'm stupid. I tryed everything (VBNullDate, VBNullString, "" and so on) except this.
Thank you very much
Vlad