I have an Access application that requires a date input in this format, YYMMDD with the day being the last day of the month. This date becomes part of a bar code as an expiry date code, that gets printed on a label. I have guidance text right above the textbox that explains how to input the proper sequence, a little grid showing the last day of the month for all 12 months and a mask that requires 6 numbers. This application has been trucking along for over a year now, and we just had our first screw up. The *only* user of the system, who has successfully input hundreds of date codes, input the date as MMDDYY, and a bushel of labels were printed before anyone caught the mistake. Is it possible to lock down the user input more completely using VBA? I'm thinking parse the input to ensure the first two digits are greater than the present year, next two are 1 through 12 inclusive, and the last two automatically populate according to the month number. I'm not looking for a how to, but any guidance on what concepts I should start investigating are appreciated.