I am posting today because I need some help to check user input is valid.
I have a field with 11 characters.
Characters 1-3 must be either 'OLD' or 'NEW'
Character 4 must be a double-colon
Characters 5-7 can be any number between 000 and 999
Character 8 must be a dash
Characters 9-11 can be any number between 000 and 999
I have tried to use an input mask but as far as I know it can only check if a character it a letter or number
To complicate matters further the user will be entering data in a form using datasheet view and all 11 characters must be entered\stored in one field.
Any help would be appreciated, Thank you.