MS Access: Show string in the date field when empty

Question

I'm looking to have my field show "dd-mmm-yy" when a date is not entered into the field, so members don't get confused and frustrated when they try to put in a date such as 11/12/20 and don't realize it needs to be in day day, month month month, year year format. Is this possible to do through the property sheet?

[date format]

Answer 1

You can set the Format property of the textbox to:

dd-mm-yyyy;;;"dd-mm-yyyy"

though I believe it will add more confusion than help.

Another method for speedy input of dates is shown in my article:

Entering ISO formatted date with input mask and full validation in Microsoft Access