Input Masks

[snowboarder]

I want to force user to input state in capital letters, ie; CA, CO, WA, etc., with two text characters only. Working in design view, I used this character: > in the input mask field property area,
which I understand (perhaps mistakenly) will convert characters to uppercase. Now, I cannot enter any info in the state field.
Any help would be most appreciated.

 

[jeremie_ingram]

Close but no bannana

Try placing the > in the FORMAT area of the properties (one row up)for the field within the TABLE. That should get the results you want. Input mask will allow you to format a field with special characters like (***)***-**** for a phone number. If you click on the ellipses button to the right of the input mask filed you will get the wizard which will give you a better idea of what it is for.