Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alternative InputMask for Date Fields

Status
Not open for further replies.

NattyP

MIS
Sep 1, 2001
45
JM
Hi,

I have set the InputMask of a date field to 99/99/00;0;_

The Short Date has been defined as M/d/yy in Control Panel->Regional Settings->Date.

How can I get Access to interpret date values as dd/mm/yy rather than mm/dd/yy given the above without having to change the Regional Setting on each user's computer?

What I have had to do is to set Format to Short Date so that the user can verify the date that he/she had actually entered.
 
Have you tried just setting the format mask in the table to d/m/yy? -Dustin
Rom 8:28
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top