Search code examples
datems-accessinput-maskpropertysheet

MS Access: Show string in the date field when empty

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]

Solution

  • 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