Proper
Returns the first letter of each word in text as uppercase and all other letters as lowercase.
Format
Proper ( text )
Parameters
text - any text expression or text field
Data type returned
text
Originated in version
6.0 or earlier
Example 1
Proper ( "ABCD" ) returns Abcd.
Example 2
Proper ( Name ) returns Yumiko Kitagawa, when the Name field contains YUMIKO KITAGAWA.