Clear date field on form from VBA

[Magster]

Hello - I'd like to clear a date field on the form via VBA. I thought that I could just say Me.EmailSentDate.Value = Null but that didn't work. After I find out how to clear the date, I hope to just save the row as shown below. I searched through a lot of books, but I guess this is so minor that I just can't find an answer.

What do I need to complete the following statement?

Me.EmailSentDate.Value = ??
DoCmd.RunCommand acCmdSaveRecord
Me.Requery

Thanks and have a great weekend...

 

[KenHigg]

me!EmailSentDate = ""

???

 

[Magster]

many thanks - I didn't think it would be that easy...

 

[KenHigg]

Glad to help -

 

[trixxnixon]

i have the same problem, but when i put in the me!fieldname = "", it crashes the program, saying the field can not be a zero length... whats up with that?

 

[KenHigg]

Sounds like you may have something else going. Can you elaborate? Maybe post your code?