1

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]

Gustav
  • 53,498
  • 7
  • 29
  • 55
Heather Dragon
  • 51
  • 6
  • 1
    Doubt that can be done with textbox bound to date/time field. Have a label with big red message "Enter as dd-mmm-yyyy". – June7 Jun 10 '20 at 17:46
  • I also have input mask on, but I was wondering if it's possible to show the string "dd-mmm-yy" when the field is blank to show members what format to type it in. – Heather Dragon Jun 10 '20 at 17:48
  • You read my first comment before I edited it. Might review again. – June7 Jun 10 '20 at 17:49

1 Answers1

2

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

Gustav
  • 53,498
  • 7
  • 29
  • 55