Microsoft Office Tutorials and References
In Depth Information
Controlling field formatting by using switches
■ Uppercase or lowercase s for the second. One s displays
the second without a leading zero; the two-digit ss dis-
plays the second with a leading zero, if needed.
■ Uppercase or lowercase am/pm for the morning or
afternoon on the 12-hour clock. This expression always
displays uppercase AM or PM unless you also include the
\* Lower switch in the same field code.
In a field that produces a text result, you can control the capital-
ization and formatting with a format switch that consists of the
characters \* followed by a keyword that specifies the change in
\* MergeFormat Applies the formatting of the field’s
previous result to the new result when the field is
\* alphabetic Displays a numeric result as the equiva-
lent lowercase letter ( a for 1, b for 2, and so forth). The \*
Alphabetic switch displays uppercase letters.
\* roman Displays a numeric result as the equivalent
lowercase Roman numeral. The \* Roman switch displays
an uppercase Roman numeral.
\* ordinal Displays a numeric result as the number fol-
lowed by st , nd , rd , or th as appropriate.
Capitalizes the first letter of each word in the
\* ordTex t Displays a numeric result as the ordinal
number spelled out in full (for example, twenty-third ).
Capitalizes the first letter of the first word in
\* CardTex t Displays a numeric result as the cardinal
number spelled out in full (for example, twenty-three ).
Capitalizes all letters in the result.
\* DollarText Displays a numeric result as the cardinal
number, with the word and inserted in place of the deci-
mal point and with the first two decimal places expressed
as a fraction (for example, twenty-three and 44/100 ).
Makes all letters in the result lowercase.
\* CharFormat Applies the formatting (such as bold,
italic, or a font name or size ) of the first character of the
field code to the entire field result.