Some Controls support Formatting; this means you can specify valid data formats for the Field, and when editing the value of the Field has been completed this format will be imposed on the value. Formatting is frequently mixed with Validation to ensure that data has been recorded in a valid state, although unlike Validation it has no additional requirement for another Field to trigger its action.
There are six kinds of formatting available in Scripting:
Formatting Type
Description
Alpha Only
Removes any non-alphabet characters.
Lower Case
Makes all characters lower case
Monetary Value
Takes the number value of the Field, and formats it with exactly two decimal places. Non-numeric characters other than a decimal (.) will return NaN.
Number Only
Removes any non-number characters from the field. Addition, subtraction, and decimal (+, -, .) characters are also removed.
Proper Case
Capitalises the first letter of every word, makes every other character lower case.
Title Case
Capitalises the first letter of a sentence, leaves every other character unchanged.
