Update with Null

[Vlad Chapranov]

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

[Lothar Haensler]

did you try

yourRecordSetVariable.Edit
yourRecordSetVariable.fields("yourfield").value = null
yourRecordSetVariable.Update



?

[Vlad Chapranov]

I'm stupid. I tryed everything (VBNullDate, VBNullString, "" and so on) except this.
Thank you very much
Vlad