Syntax: Proper ( text )
textAny expression that resolves to a text string.
Data type returned: Text
Returns the specified text string with the initial letter of each word capitalized and all other letters as lowercase.
The Proper() function is one of three case-changing functions in FileMaker. The other two are Lower() and Upper().
The Proper() function is often used as part of an auto-entered calculation formula to reformat a users 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.
Proper ("this is a TEST")
Returns This Is A Test.
Returns 123 Main Street when Address contains "123 main street".
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information