Format string

Use a format string to format the data displayed in the query. First, select the format type. Then, type a format string to modify the format type you selected. The valid options depend on the format type you select. A format string must begin with a % sign and end with a format type character:

[%] [type]

If required, you can also include:

• An argument index specifier. See Argument index specifier
• A left justification indicator. See Left Justification Indicator
• A width specifier. See Width specifier
• A precision specifier. See Precision Specifier

[%] [index:] [-] [width] [.precision] [type]

To specify how many decimals to use in a format string, set the format string to the normal format you can use. Add the precision specifier a decimal point and the number of digits to follow it before the format string character but after the initial %. For example:

• Field Type: Float
• Format Type: ftCurrency.
• Format String: %.4f
• Data (Unformatted): 3.1415926&ldots;
• Result: 3.1416

You can use any of these format strings:

• Boolean field format strings. See Boolean field format strings
• Currency and Phone field format strings. See Currency and Phone field format strings
• Date or Time field format strings. See Date/Time field format strings
• Fixed field format string. See Fixed field format strings
• Integer field format strings. See Integer field format strings