Date Format Problem
In the current mde access application that I have created,
I am facing some problem with the date field.
When the program is ported to different computers, the date format is creating problem. I am not referring to the simple DD/MM/YY or MM/DD/YY format problem. My problem lies in the "language" of the system.
For example: I have a text box that only accepts date.
The format I am expecting is the Medium date format ==> dd-mmm-yy
i.e. 02 march 2006 ==> 02-Mar-06
BUT, when I bring the program over to a PC with the native language set to "German (Germany)", entering 02-Mar-06 will result in an error. And the only way i can enter the date is to enter it using the german short form for March ==> Mrz ==> 02-Mrz-06
My question is: How can I force the program to follow a stipulated date format? This is crucial because I make use of date groupings to perform calculation and I don't want Mar and Mrz to cause me problems and crash my program.
Any help is greatly appreciate!
Thanks in advance!