Day/Month/Year as ##/AAA/####

  • Thread starter Thread starter Iram
  • Start date Start date
I

Iram

Hello.
I am using Access 2003 and need an input mask of ##/AAA/####

Since the db will be used in Mexico I need day as two digits ##, month as
three letters they can type and year as four digits.

Can you please help?
Thanks.
Iram
 
Set the Format property of your text box to:
dd\/mm\/yyyy

It's fairly close to the Medium Date format too.
 
When I add this dd\/mm\/yyyy to either a text field or a Date/time field and
try to add data via the table I get a beep noise and the numbers I type don't
replace dd\/mm\/yyyy
Would you know why?
I am probably doing something wrong...


Iram
 
I suggested placing it in the Format property.

IME, the Input Mask serves little purpose, except to slow down a good data
entry operator.

If you leave the Input Mask blank, the user can type using any format they
want, even omitting the year if it is the current year.
 
Back
Top