Format (Field)

Specifies the value of an expression in a field control.

  1. In the Report Expression dialog box, when you have a valid expression, press Format.

    Information on the Report Expression dialog box is available in Report Expression.

    The Format (Field) dialog box is displayed.

  2. Type the format expression in Format, or use the options below.
  3. Select Character, Numeric, or Date type.

  4. Use the following options in the dialog box to edit the format expression, based on the selected data type (Character, Numeric, or Date).

    Choose this To do this

    To Upper Case

    (Character selected) Convert all characters to uppercase.

    Ignore Input Mask

    (Character selected) Display, but not store, non-format characters.

    Left Justify

    (Numeric or Character selected) Align all numeric data at the leftmost position in the specified field.

    Right Justify

    (Character selected) Align data to the right.

    Center Justify

    (Character selected) Center data.

    Blank If Zero

    (Numeric selected). If field value is zero, nothing is displayed.

    (Negative)

    (Numeric selected) Display negative numbers in parentheses.

    SET Date

    (all types) Display data as a date using the current SET DATE format.

    British Date

    (all types) Display data as a European (BRITISH) date.

    CR If Positive

    (Numeric selected) Display "CR (credit)" after positive numbers.

    DB If Negative

    (Numeric selected) Display "DB (debit)" after negative numbers.

    Leading Zeros

    (Numeric selected) Display all leading zeros.

    Currency

    (Numeric selected) Display currency format.

    Scientific

    (Numeric selected) Display format in scientific notation. This format is useful for very large or very small numbers.

 

Related Topics: