I have a date in my database set as a short date which is not required and not indexed. I am using ADO and the date is entered via a text box on my screen.
If the date is not entered at all everything is fine when the record is saved.
If it is entered and the next time that record is accessed the date field in the text box is deleted (len of text is 0)Then I get an error when the record is updated because of the date format - how can I save back an empty date??

I need to be able to blank it out or to have a date there.

Thanks for your help.