Date format changes

[cpurpleturtle]

Hello. I have a subform where the user has to enter a date in one of the
table columns. I have the format set to dd/mm/yyyy because it is being used
in India. When I enter some dates, it automatically changes it. Here are
some examples of what it is doing. How do I stop it from doing that?

Enter 5/10/2008 and it changes to 10/5/2008
Enter 07/16/2008 and it changes to 16/07/2008
Enter 16/07/2008 and it stays the same

 

[Douglas J. Steele]

Check Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003 Access
Answers column for Pinnacle Publication's "Smart Access" newsletter. (The
column and accompanying database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)