I have a field called Case Number and want this field to allow a maxinum of 10 characters which I have set in my table properties. However, I want the Input Mask to be set to allow the user to enter a case number like this: 11-51-0001AX
I want the last two characters to accept a number or an alphabetic character. Sometimes we will have a Case Number 11-51-00001A or 11-51-0000DL or 11-51-0000DN.
The first Two numbers is Last two of the year. The next two is the County #.
Is this possible with a Input Mask?