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?