Access Date Format Input

[rzhang]

Hi,

We have an Access Application which works fine for most of the users.
But there is one user who has the date input problem.

When he enter a date field from a form, i.e. 09/03/2004 (Sept. 3,
2004), the value always gets flipped into 03/09/2004(Mar 9, 2004) as
soon as the cursor leaves that date field.
When he enters 09/24/2004, the value doesn't get flipped.
My discovery is that any value in between '/' under 12 will be flipped.

The format for the field is Short Date. The sample for it is
'6/19/1994'.
The regional short date format setting from Control Panel is M/d/yyyy,
Date separator is '/'.
MS Access version is 2002 SP3 and it's running on Windows XP.
Any insight on this? It drives me crazy!

Thanks

[Douglas J. Steele]

You're sure about the short date format on his machine? That's really the
only thing that's make sense.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<rz****@allstate.ca> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Hi,

We have an Access Application which works fine for most of the users.
But there is one user who has the date input problem.

When he enter a date field from a form, i.e. 09/03/2004 (Sept. 3,
2004), the value always gets flipped into 03/09/2004(Mar 9, 2004) as
soon as the cursor leaves that date field.
When he enters 09/24/2004, the value doesn't get flipped.
My discovery is that any value in between '/' under 12 will be flipped.

The format for the field is Short Date. The sample for it is
'6/19/1994'.
The regional short date format setting from Control Panel is M/d/yyyy,
Date separator is '/'.
MS Access version is 2002 SP3 and it's running on Windows XP.
Any insight on this? It drives me crazy!

Thanks

[RS200Phil]

I have seen this before on a server running ASP code. In this case I
went right through the registry looking at the Control Panel /
International settings. You need to be sure that every instance has
the country ID and the date formatting set the same.
This kind of thing is a lot more common for us Brits!

Phil

[rzhang]

Sorry to reply a bit late.

The problem is not related to the registry since I check every entry
under International settings from registry.

The client machine is a regular desktop not a server. All what I did is
to open the table in design view and go through the date format again
which read the way as the registry stores.

I went back to the program and found that every date field is working
without flipping.

Don't know the reason yet. Is there Access local setting overriding the
system setting somehow?

Anyway I got it fixed eventually.

Thanks

RS200Phil wrote:

I have seen this before on a server running ASP code. In this case I
went right through the registry looking at the Control Panel /
International settings. You need to be sure that every instance has
the country ID and the date formatting set the same.
This kind of thing is a lot more common for us Brits!

Phil

[Michael \(michka\) Kaplan [MS]]

Access has a Format property, yes -- and it overrides the system when it is
specified.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

<rz****@allstate.ca> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...

Sorry to reply a bit late.

The problem is not related to the registry since I check every entry
under International settings from registry.

The client machine is a regular desktop not a server. All what I did is
to open the table in design view and go through the date format again
which read the way as the registry stores.

I went back to the program and found that every date field is working
without flipping.

Don't know the reason yet. Is there Access local setting overriding the
system setting somehow?

Anyway I got it fixed eventually.

Thanks

RS200Phil wrote:

I have seen this before on a server running ASP code. In this case I
went right through the registry looking at the Control Panel /
International settings. You need to be sure that every instance has
the country ID and the date formatting set the same.
This kind of thing is a lot more common for us Brits!

Phil