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 necessary, you can also include:

• an argument index specifier
• a left justification indicator
• a width specifier
• a 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 would use. Then, 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 the following types of format strings:

• Boolean Field Format Strings
• Currency and Phone Field Format Strings
• Date/Time Field Format Strings
• Fixed Field Format Strings
• Integer Field Format Strings

Related Topics

Query Builder Overview