interesting issue with a date format

[Sport]

I have a text field set with a format of dd/mm/yy\ hh:nn
Everything works fine, except if you go back to it to edit it, the format
switch's to mm/dd/yy which is the setting on that local pc. It's nothing
big, but it is proving confusing to those who use it. Any way to avoid
this?

 

[Douglas J. Steele]

Nope, no way to avoid it.

You might want to read Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html or what I have at
http://members.rogers.com/douglas.j.steele/SmartAccess.html

 

[TC]

I'm not sure I follow this. My apps set the format of all date textboxes
programatically, to a suitable value, depending on the user's locale. I've
never had a problem with those formats changing, or failing to "stick". The
OP is suggesting that his format fails to stick, no? What is your
interpreation of his problem?

Cheers
TC

 

[Douglas J. Steele]

For example, the short date format on my machine is yyyy-mm-dd. If I bind a
query to a form and set the format to dd/mm/yyyy for the text box that's
displaying the date, opening the form, the dates are in dd/mm/yyyy format.
However, sometimes (not always) when I go to the text box to change the
date, it switches from being displayed in dd/mm/yyyy format to yyyy-mm-dd
format.

 

[test]

Ok, thanks, understood. It would be interesting to know whether the format
prop had disappeared from the control, or was still there but being ignored
....

Cheers,
TC