interesting issue with a date format

  • Thread starter Thread starter Sport
  • Start date Start date
S

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?
 
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
 
I've had experiences where the date format that the textbox is set to
doesn't correspond to the Short Date format specified through the Control
Panel. When you key into the date field, it gets presented back in whatever
the Regional Settings are, not what the format has been set for the textbox.
That sounds like what the OP is describing.
 
Hi Douglas

Still not sure I follow you. Is this it: "When the format of a textbox is
set to something other-than the PCs Short Date format, and you key a date
into that textbox, it sometimes is presented back as ... "? What is the
"..." ?

TIA,
TC
 
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.
 
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
 
Back
Top