The Best Way to Reset a date or date/time to empty is:
Blank Field myDate, myDateT, myNumberWhy?
- You don't need to care which datatype
- Blank will display instead of
0 for numeric field!
>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.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.