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

[floydman]

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 ?

 

[macca the hacke]

Do you have default value set as 0??

If you delete date in a text box then should just be blank.

 

[floydman]

Thankyou, it was.