Input Mask

[busterg]

I need an input mask that figures out the first part of the year date when the second part is entered. For example once I type in 02 the field will diplay 2002 for the year, but if I type in 99 it will display 1999 for the year. These dates are always between 1940 and 2002. Is this possible? If so how do I do it.

Thanks in advance

 

[David R]

I hate using Input Masks on date fields for this very reason. Microsoft is fairly reasonable about being able to figure out when a date is supposed to be; let it do so without input masks and just use the Format setting to control what it looks like (mm/dd/yyyy, presumably - on many computers this is Short Date). Depending on the computer's regional settings it will either show two dates or four for the field, or you can create a custom format to show all four years.

Otherwise you're going to have to wriggle around with code to determine the date and then input it correctly, which seems more trouble than it's worth.