The Format Constants category is displayed on the Format Scripts dialog. The Format Constants category of the Fields list box list valid values for the matching property; for example, the borderStyle property can be set to one of the Border Style constant values of BorderNone, or BorderSingle, and the alignment property can be set to one of the Alignment constant values of AlignmentCenter, AlignmentLeft, or AlignmentRight. The following table lists the constants in the Format Constants category of the Fields list box.
Constant Heading and Names | Values |
---|---|
Colors | For backColor and fontColor properties |
Black | 0 |
Blue | 16711680 |
DarkBlue | 12582912 |
DarkGray | 4210752 |
Gray | 12632256 |
Green | 32768 |
LightGreen | 65280 |
LightYellow | 8454143 |
Mauve | 16711935 |
Purple | 12583104 |
Red | 255 |
White | 16777215 |
Yellow | 65535 |
None | -1 (for backColor only, to set no color at all; that is, transparent) |
Alignment | |
AlignmentLeft | 0 |
AlignmentRight | 3 |
AlignmentCenter | 6 |
Border Style | |
BorderNone | 0 |
BorderSingle | 1 |
Date Order | |
MonthDayYear | 0 |
DayMonthYear | 1 |
YearMonthDay | 2 |
Month Format | |
MonthFullName | 1 |
MonthNumber | 4 |
MonthNumberLeadingZero | 3 |
MonthShortName | 2 |
Negative Format | |
NegNumberInBrackets | 0 |
NegNumberLeadingSign | 1 |
NegNumberLeadingSignSpace | 2 |
NegNumberTrailingSign | 3 |
NegNumberTrailingSignSpace | 4 |
NegCurrLeadingSymbolBrackets | 0 |
NegCurrLeadingSignSymbol | 1 |
NegCurrLeadingSymbolSign | 2 |
NegCurrLeadSymbolTrailingSign | 3 |
NegCurrTrailingSymbolBrackets | 4 |
NegCurrLeadSignTrailingSymbol | 5 |
NegCurrTrailingSignSymbol | 6 |
NegCurrTrailingSymbolSign | 7 |
NegCurrLeadSignTrailSpSymbol | 8 |
NegCurrLeadingSignSymbolSp | 9 |
NegCurrTrailingSpSymbolSign | 10 |
NegCurrLeadSymbolSpTrailSign | 11 |
NegCurrLeadSymbolSpSign | 12 |
NegCurrTrailingSignSpSymbol | 13 |
NegCurrLeadingSymbolSpBrackets | 14 |
NegCurrTrailSpSymbolBrackets | 15 |
Positive Format | |
PosCurLeadingSymbol | 0 |
PosCurrTrailingSymbol | 1 |
PosCurrLeadingSymbolSpace | 2 |
PosCurrTrailingSpaceSymbol | 3 |
Output Type | |
OutputCSV | 3 |
OutputHtml | 2 |
OutputRtf | 4 |
OutputPrinter | 0 |
OutputText | 6 |
OutputXml | 5 |
Picture Stretch | |
StretchNone | 0 |
StretchToControl | 1 |
StretchControlTo | 2 |
StretchProportional | 3 |
StretchPictureProportional | 4 |
StretchCenterPicture | 5 |
Although the fontColor and backColor values are not restricted to the colors listed in this table, they are the common ones.