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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Iram" wrote in message
...
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

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" wrote:

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Iram" wrote in message
...
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

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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Iram" wrote in message
...
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" wrote:

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

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

"Iram" wrote in message
...
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.