I have a text box on a form that is tied to a date field from a table. I have an input mask set on the field for Short Date. When I type something like 01/33/01, I get the proper message that says the date is invalid. However, if I type something like 56/01/02 it takes the entry and changes it to look like 01/02/56. What is up and how do I get it to stop that and just tell me that anything greater than 12 or less than 01 is invalid? Lastly, Does access 97 have a control where if you click on the box you get a drop down calendar that you can pick dates from?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Field Problems - Help
- Thread starter ChemistZ
- Start date
tomschafer
Technical User
Change the format to "mm/dd/yy". There is a Calendar ActiveX Object but I can not remember the name of it.
- Status
Similar threads
