Currency and Phone Field Format Strings

The table below lists the format string options for currency and phone number fields.

Field Type

Option

Description

Currency

m

Money. The format of the field must be a floating-point value. The value is converted to a string that represents a currency amount.

Phone Number # Use the # sign to indicate how you want a number to display. You can use any character as a separator except letters and numbers. The default phone number format is (###) ###-####.

Related Topics

Assigning a Query Layout

 

Tell us how we can make the Help better.