Formula for proper case in a text field 4

[chrismilardo]

I have a 50-character text field that is in all upper case, and I want to change it to proper case- the first letter of each word in upper case, and the rest in lower case. I've created a very basic formula to take care of one-word entries:

left({field},1) + lowercase(mid({field},2,50))


But I cannot figure out how to get multi-word entries, like "THE PROBLEM FORMULA" to format correctly. Any help would be greatly appreciated!

[sig][/sig]

 

[kenhamady]

There is a DLL that you can download that does this. Just follow the installation instructions.

http://support.seagatesoftware.com/communityCS/FilesAndUpdates/uflcaps.exe.asp

[sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[chrismilardo]

Worked like a charm - thank you very much! [sig][/sig]