date is american

D

Database User

Date of my database is in american how can i change it that when i type in
1-6-05 it will give me 1-June-05 not 6-Jan-05
 
A

Allen Browne

Open the Windows Control Panel | Regional Options, and set the date format
there. Access will then interpret what you type into the user interface
(forms, query design), according to your local format.

For more detail on avoiding the 3 cases where Access can misunderstand your
dates, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
 
Top