Date format with input masks

[Sue]

I have created a table with a date field that has an input mask of
99/99/00;;_.

When I put in the year date of 1945, Access makes it into 2045. Is there a
way to fix this so that I can put in dates of 1900 and 2000?

Thanks so much!

 

[Larry Linson]

I have created a table with a date field that has an input mask of
99/99/00;;_.

When I put in the year date of 1945, Access makes it into 2045. Is there a
way to fix this so that I can put in dates of 1900 and 2000?

Your mask only allows two-digits for the year, so Access assumes the rest.
Change it to accept 4 digits for the year. In fact, one of the few uses I
have made of input masks (they are cumbersome unless the user is tabbing
between fields) was in Y2K remediation code, to _force_ four digit years.

Larry Linson
Microsoft Access MVP

 

[Sue]

Thank you very much! I will try it.

Your mask only allows two-digits for the year, so Access assumes the rest.
Change it to accept 4 digits for the year. In fact, one of the few uses I
have made of input masks (they are cumbersome unless the user is tabbing
between fields) was in Y2K remediation code, to _force_ four digit years.

Larry Linson
Microsoft Access MVP