Access Date format reversal

  • Thread starter Thread starter AlexM
  • Start date Start date
A

AlexM

I have an interesting problem with an unbound text box:
Access 2000
- .Format = Short Date
- .InputMask = 99/00/00;0;_
In Regional Settings short date format is MM/dd/yy
If I enter 01/08/09, it will reverse the year and the month and give me
09/08/01
when I press enter. I've seen other date issues, but nothing like this.
I am wondering if AutoCorrect is doing this.
Could it be anything to do with Regional Settings of the server where the
file is located (it really shouldn't) or maybe if Regional Settings are
pushed via group policy and what's in Control Panel is not really the date
format?
I am having a no fun time resolving this especially since I don't have
access to the Environment where this runs (Citrix) and can't test it properly.

I've read Allen Browne's article on dates and it's something like the #1
item on the list but it's not quite like it. I enter a valid date and it will
always reverse. it

Any thoughts would be appreciated.

Thanks
 
No it doesn't.
I thought changing Allow AutoCorrect propety to No might do something.
I 've sent that to the client to test as I can't replicate this anywhere
except on their desktops (which are remote to me).

thanks!
 
The AutoCorrect property of the text box won't make any difference here.

IME, input masks for dates serve no useful purpose. A good data entry
operator can enter any date this year with 3 to 5 keystrokes if you don't
use an input mask, e.g. Jan 1 would be just: one, space, one. Using an input
mask requires them to use twice as many keystrokes, and doesn't solve any of
the data input problems.

You may find that they have a different date format in their Regional
Settings.
 
Thanks Allen,
I did look at the Regional settings on the desktop that was tested and it is
the same as mine. A colleague of mine suggested the server that the file
resides on should be check as well. I don't know why that would be a factor
but I put in a request to check that as well.
These users that enter the information are occasiaonal computer users and
the input mask was requested.
My only thought was the some other Regional Setting was pushed by the domain
policy and is in effect but it doesn't change the appearance of the date
formats in the control panel of the PCs in the domain (something like
firewall).
Thanks
 
Back
Top