What's the best way to reset a date or date/time field in a record. For example, I put a date or date/time in a field in a record and then later I decide to blank it out. How should I do it to prevent Data Type Mismatch or some other error?

Also, I also put the date or date/time field in a textbox on a form and want to give the user the option to blank out the date or date/time field in the textbox on the form. What's the best way to do that too?

The Date and Date/Time values are coming from the system and getting plugged into the record and the form when the user clicks a checkbox.

Thanks for the advice. I have my own so-so way of doing it, but there must be a nicer way to do it. I have lots of books, but they don't cover this topic very well.

Steve Kramer
Kramer & Kramer Design
http://members.aol.com/gocartoons
gocartoons@aol.com
Home of more than 260 original, off-the-wall cartoons by yours truly.