Integer Mask Options¶

The mask format is in the format 'LZ;NF;TS' where:

Code	Representation
LZ	Leading Zeros. Enter a 0 for a leading zero. Leave empty for NONE.
NF	Negative number Format.
TS	Thousand Separator.

Mask	Explanation
";(123);"	Format the integer with no leading zero, negative values between parentheses, and no thousands separator.
"0;- 123;."	Format the integer with leading zeroes; negative values separated with a space from the minus sign and a dot as the thousands separator.

The double quotes in the example masks are needed when using the FormatInteger function and need to be omitted when used via the field properties dialog.