No input mask will do that. If you define the field as a date/time data type, Jet will ensure that only a valid date is accepted. You only need to edit the data if you need to limit the date to a particular range.
But i need to verify the value like (dd) has a value of 0-31, (mm), has a value of 1-12, ensuring a valid date is input.
- this will not ensure that a date is valid. A real date edit (such as the one built in)validates day within month within year and knows which years are leap years.
FYI, I never use input masks for date fields. I find them more annoying than useful. They will limit characters to numeric and force certain numbers of characters to be entered but input masks contain no concept of a date and therefore will allow virtually any numeric value to be entered. It is only when the record is being saved that Jet edits the field for a valid date that an error occurs.
