Proper()

Proper()

Category: Text

Syntax: Proper ( text )

Parameters: text ”any expression that resolves to a text string.

Description: Returns the specified text string with the initial letter of each word capitalized and all other letters as lower case.

Examples:

 Proper ("this is a TEST") 

Returns This Is A Test .

 Proper (Address) 

Returns 123 Main Street when Address contains "123 main street" .

Comments:

The Proper() function is one of three case-changing functions in FileMaker Pro 7. The other two are Lower() and Upper() .

The Proper() function is often used as part of an auto-entered calculation formula to reformat a user 's entry with the desired case. For instance, in a City field, where you would expect the first letter of each word to be capitalized, you could set up an auto-entry option to enter Proper(City) and uncheck the option to not replace existing value. Then, if a user were to type SAN FRANCISCO , upon exiting the field the entry would be reset to San Francisco .