Format (Field) Dialog Box

  • Article

Specifies the value of an expression in a field control. This dialog box appears when you have a valid expression in the Expression box of the Report Expression dialog box and choose the dialog button for Format.

  • Format
    Makes it possible for you to type the format expression instead of setting the options below, or type a format template.
  • Character
    Specifies Character data type, and displays the appropriate editing options.
  • Numeric
    Specifies Numeric data type, and displays the appropriate editing options.
  • Date
    Specifies Date data type, and displays the appropriate editing options.

This group changes according to the data type (Character, Numeric, or Date). Selecting these options places a formatting code in the Format box.

  • To Upper Case (Character type)
    Converts all characters to uppercase.
  • Ignore Input Mask
    Displays, but does not store, nonformat characters.
  • Left Justify (Numeric and Character type)
    Begins all numeric data at the leftmost position in the specified field.
  • Right Justify (Character type)
    Prints data flush-right in field.
  • Center Justify (Character type)
    Centers data in field.
  • Blank If Zero (Numeric type)
    If field output is zero, does not print the zero.
  • (Negative) (Numeric type)
    Places negative numbers in parentheses.
  • SET Date (all types)
    Displays data as a date using the current SET DATE format.
  • British Date (all types)
    Displays data as a European (BRITISH) date.
  • CR If Positive (Numeric type)
    Displays CR (credit) after positive numbers.
  • DB If Negative (Numeric type)
    Displays DB (debit) after negative numbers.
  • Leading Zeros (Numeric type)
    Prints all leading zeros.
  • Currency (Numeric type)
    Displays currency format as specified on the Regional tab in the Options dialog box.
  • Scientific (Numeric type)
    Displays format in scientific notation (useful for very large or very small numbers).

See Also

Calculate Field Dialog Box | Regional Tab, Options Dialog Box | Report Designer | Report Expression Dialog Box | SET DATE | Formatting Field Controls | Creating a Report Layout