Try OpenEdge Now
skip to main content
Online Help
Introducing the ABL GUI Designer : Reference : GUI Designer dialogs : AppBuilder dialogs : Other AppBuilder dialogs : Format dialog for Numeric field
 
Format dialog for Numeric field
The Format dialog helps you to format the selected Numeric field.
You can access this dialog by clicking Format Help in the Column Editor dialog (for Browse).
The Format dialog for Numeric field includes the following options:
Number Format
Enter a valid display format for the selected numeric field (->,>>>,>>9 is the default).
Total Number of Digits
Enter the total number of digits allowed for the selected field (7 is the default).
Number of Decimal Places
Enter the number of decimal places to the right of the decimal character to display for the field value.
Use Thousand's Separator
Select to display a comma (,) as the thousands separator character for the field value (default).
Suppress Leading Zeros
Select to suppress any leading zeros in the field value.
Show as Zero
Select to display zero values in the field as blank.
Show as Asterisk
Select to display an asterisk (*) as the leading sign for the field value.
Leading Text String
Enter a text string to display before the number, such as a currency sign.
Trailing Text String
Enter a text string to display after the number, such as a currency sign.
Show Leading Sign Always
Select to display all values with a leading sign.
Show Leading Sign on Negative Only
Select to display only negative values with the leading sign (default).
Show Trailing Sign Always
Select to display all values with a trailing sign.
Show Trailing Sign on Negative Only
Select to display only negative values with the trailing sign.
Show Negative Numbers in Parentheses
Select to display negative values between parentheses '()'.
Show Negatives With Trailing 'CR'
Select to display negative values with the string "CR" after it.
Show Negatives With Trailing 'DB'
Select to display negative values with the string "DB" after it.
Show Negatives With Trailing 'DR'
Select to display negative values with the string "DR" after it.
Show Negatives With Trailing 'cr'
Select to display negative values with the string "cr" after it.
Show Negatives With Trailing 'db'
Select to display negative values with the string "db" after it.
Show Negatives With Trailing 'dr'
Select to display negative values with the string "dr" after it.
Allow Positive Numbers Only
Select to allow positive numbers only.
Standard
Select to format the selected field to the default ABL format for numbers, which is: ->,>>>,>>9, 7 total digits, comma as thousands separator, and show leading sign on negatives only.