date input mask changes when converting access 97 to access 2000

M

mspL4

Hey!,

I've just recently converted a database from Access 97
format to Access 2000 and everything seems fine apart from
anything to do with dates.
I've checked the table setup and the input masks on both
databases and they are the same, but when I enter a date
into a form, the year field automatically prompts me for 4
digits instead of 2, and on entries where the year is
1904, (or 00 or 01 or 02 or 03) access 2000 automatically
assumes the date is this millenium and adds the other 2
digits.

Any way to work around this?

Thanx in Advance

msp
 
J

John Nurick

IIRC this relates to "millennium bug" fixes in Access 2000.

In Control Panel|Regional Options, there's a setting on the Date tab
that controls how 2-digit years are interpreted.

If you omit the input mask, things will be easier for users because
Access can interpret most date formates correctly (e.g. 21 Jan 04 or
21/1/04).
 
Top