Proper Case

[Brad Christie]

Is there a way of automatically converting ALL CAPS or all lower case entered
into a text box to Proper Case?

Thanks

 

[Anuma(GGK Tech)]

Hi,

If you want to translate data from upper case to lower case, then use
following function:

translate(Fieldname, 'QWERTYUIOPLKJHGFDSAZXCVBNM',
'qwertyuioplkjhgfdsazxcvbnm')

If you want to translate data to Upper case then use followimng funtion:

translate(Fieldname, 'qwertyuioplkjhgfdsazxcvbnm',
'QWERTYUIOPLKJHGFDSAZXCVBNM')


Fieldname  your text box name

Double click on the text box and select “fx†button in the default value
field and enter above function.

I think this will help you.

 

[Brad Christie]

Unfortunately Those Don’t Give You Proper Case, As In This Sentence.
Thanks for you help.