I would like to validate input into a database to make sure it conforms. The format that I want is 'Y########' where the 'Y' will always be a 'Y' and the #'s can be any number; the length is also fixed to 9. I've tried finding how to do this all over and I'm sure it's something easy to do, so any help would be appreciated!

Have you tried putting an INPUT MASK into the field's properties in table design view?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thurston,

Change the input mask to \Y99999999 on the field in the table. Make sure you have the same input mask on your input form. Set the field size to 9 and make it a text field.

Kevin

dartcoach

Thanks! I was trying to validate any input...this was much easier.

Would there be any way to make sure that the letter is in caps, because I can enter it in lower case currently...I'm guessing this is where I would validate?

Nevermind, it accepts it and then automatically capitallizes it.