Hi all,
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!

Scripts82

__________________
Scripts82

The only way to do this is to use a text field, perhps with an input mask that you create - not a date input mask. Since the Date field refers to the system date and time formats (like currency does) it will always default to that local format.

If you use a text field with data validation that you create, you can do this. The coding for your date calculations may be a little difficult, but it is doable this way.

HTH

mmcdonal

Hmm... ok... that was the last thing on my mind...
Will do some experiments with the dates first before deciding whether to change it. Thanks mmcdonal!

Scripts82