Specifications

CHAPTER 8 Displaying and Validating Data
Users Guide 265
Table 8-1 lists the blue, green, and red values you can use in the formula to
create other colors.
Table 8-1: Numeric values used to create colors
Using special
characters
To include a character in a mask that has special meaning in a display format,
such as [, precede the character with a backslash (\). For example, to display a
single quotation mark, enter \'.
Number display formats
A number display format can have up to four sections. Only the first is
required. The three other sections determine how the data displays if its value
is negative, zero, or
NULL. The sections are separated by semi-colons:
Positive-format;negative-format;zero-format;null-format
Special characters
Table 8-2 lists characters that have special meaning in number display formats.
Table 8-2: Characters with special meaning in display formats
Percent signs, decimal points, parentheses, and spaces display as entered in the
mask.
Blue Green Red Number Color
0 0 255 255 Red
0 255 0 65280 Green
0 128 0 32768 Dark green
255 0 0 16711680 Blue
0 255 255 65535 Yellow
0 128 128 32896 Brown
255 255 0 16776960 Cyan
192 192 192 12632256 Light gray
Character Meaning
#A number
0 A required number; a number will display for every 0 in the mask