Validation rule for text box not using exact case

[TonyG]

I put in a validation rule property for a text box field on a form. Specifically, it is for a two character state field. The validation rule looks like this "[State]"="AL" Or "AK" Or "AR" Or ..." etc. When i run the form it accepts only the valid states in the validation rule, but it allows it to be entered in lower case as well as CAPS. I want it to only allow CAPS.

Any help would be appreciated.

Thanks,
Tony

 

[gusbrunston]

Hi.
I think this works: in the property sheet, data, input mask enter >LL
Good luck
Gus Brunston
An old PICKer
padregus@home.com

 

[TonyG]

Thanks for your reply Gus.

Your suggestion worked perfectly.

Tony