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

[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

 

[Allen Browne]

Set the Format property of your text box to:
dd\/mm\/yyyy

It's fairly close to the Medium Date format too.

 

[Iram]

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

 

[Allen Browne]

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.