Requiring Capitalization in a field.

[MJG]

Is there a way to force capitalization in a field?

Thanks

[ernst]

Hi MJG,

You could add field validation to your text field. If you want the user to enter data with 'all caps' then the calculation for the validation would be:

Case(Exact(YourTextField, Upper(YourTextField)), 1 , 0 )

You could also use a calculated field, derived from the text input field. For 'all caps' the calculation would be:

Upper(YourTextField)

Regards,

Ernst.

[-Queue-]

blah blah Case is redundant blah Exact( field, Upper(field) ) boolean blah blah