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

Does removing the input mask make any difference?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AlexM" <(E-Mail Removed)> wrote in message
news:FC1D5380-3125-445B-84D0-(E-Mail Removed)...
>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

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!


"Allen Browne" wrote:

> Does removing the input mask make any difference?
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "AlexM" <(E-Mail Removed)> wrote in message
> news:FC1D5380-3125-445B-84D0-(E-Mail Removed)...
> >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
>
>

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AlexM" <(E-Mail Removed)> wrote in message
news:83C52927-203C-4786-80DC-(E-Mail Removed)...
> 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!
>
>
> "Allen Browne" wrote:
>
>> Does removing the input mask make any difference?
>>
>> "AlexM" <(E-Mail Removed)> wrote in message
>> news:FC1D5380-3125-445B-84D0-(E-Mail Removed)...
>> >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

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



"Allen Browne" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "AlexM" <(E-Mail Removed)> wrote in message
> news:83C52927-203C-4786-80DC-(E-Mail Removed)...
> > 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!
> >
> >
> > "Allen Browne" wrote:
> >
> >> Does removing the input mask make any difference?
> >>
> >> "AlexM" <(E-Mail Removed)> wrote in message
> >> news:FC1D5380-3125-445B-84D0-(E-Mail Removed)...
> >> >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
>
>