Date format with input masks

  • Thread starter Thread starter Sue
  • Start date Start date
S

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!
 
Sue said:
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?
Click to expand...

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
 
Thank you very much! I will try it.

Larry Linson said:
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
Click to expand...
 
Back
Top