dates in an Access database

[Caro]

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.

Better get hold of a white paper by Ken Getz on Dates and Time in Access. Check for Ken Getz at the FMS Website. that article seems to be very good on dates and time in access. It is rather not straight forward in access97. in access 2000 the situation is better.

Gotora

[Caro]

Do you have a web site address? I have searched for FMS and got no replies?