Formula - Proper (self)

Discussion created by ajayz on Mar 24, 2015
Latest reply on Mar 25, 2015 by ajayz

I seem to be having an issue with using the "Proper" formula.


I have a field called "Prepared_by" which allows the user to enter their name.  I want to stop formatting issues of all cases or all lower cases etc.

I've set up a calculated value on the Auto-Enter Tab with the following formula:


Proper(TextFormatRemove ( Self ))


I've removed the check box - Do not replace existing value of the field if (any)


From what I understand - when the user enters their name the format will be correct to "Tony Smith" in stead of TONY SMITH


However, when I test the field its not doing anything.?


What have I missed?