PDA

View Full Version : Solved: Validation Rules



BarkersIT
03-16-2007, 08:25 AM
This should be easy but I cant get it to work.

I have a field on a table for Serial Numbers of products. Each serial number is 7 digits long and made up of numbers and letters.

I want a rule so that all of the letters entered by the user through the form are converted to upper case.

I believe that ">" is to convert to upper case.

I put AAAAAAA in the input mask & > into the validation rule.

I know this is wrong as it doesnt work. What should I write?

Thanks

OBP
03-16-2007, 11:08 AM
The > should be in the field's "Format" not validation rule.

BarkersIT
03-19-2007, 02:08 AM
OBP, comes up trumps again.

Thanks. This database may look professional yet.