When a user deletes a date, stop displaying 31-Dec-1999 ?

floydman

Registered User.
Local time
Today, 08:54
Joined
Aug 29, 2007
Messages
16
What is the best way to handle a deleting a date value ? I have an unbound form where the user can delete a date value, whenever they do this the form then displays 31-Dec-1899 (which I understand is the zero number value for the date). How do I stop the Access form displaying the zero value and have it display just a blank text box ?
 
Do you have default value set as 0??

If you delete date in a text box then should just be blank.
 
Thankyou, it was.
 

Users who are viewing this thread

Back
Top Bottom