Auto Capitalize and Auto Caps all letter in one field

[chadski021]

Is there a way to Auto Capitalize and auto Caps all letter in a single field? example if i type canada it should be Canada and if i type ak it should be AK

[LaRetta]

Hi Chad,

 

The suggested approach is to format the display of the field-value instead of changing the actual data.  If you select the field, you can specify in Inspector > Behavior > Text the Styles pop-up Uppercase for state field AK and Title Case for Canada field.

 

However, if you have both within a single field then you will have to use more complex techniques.  You can use PatternCount() to test for specific string (or probably a custom function) but it is suggested that you have a table holding the states and countries (maybe also city and zip).   If you have such a table then it would be easier. 

 

But the data SHOULD be in separate fields.

Edited May 14, 2013 by LaRetta