Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

Description:

Format one or more numeric fields with the same mask. The mask may be a built in format, or a custom mask.

Usage:

FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld
[WorkWith], FieldList, Mask, bBlanks2Zero, IfLenFld
[WorkWith], FieldList, Mask, bBlanks2Zero, [""]
[WorkWith], FieldList, Mask, [""], [""]

When inside a WorkIf Block:
FieldBase, FieldList, Mask, bBlanks2Zero
[WorkWith], FieldList, Mask, bBlanks2Zero
[WorkWith], FieldList, Mask, [""]

FieldList should be a space separated list of Fields to have Mask applied to.

bBlanks2Zero if false (blank) will leave all blank values as blank. If bBlanks2Zero is true (not blank) then any blank values will be set to zero before applying the Mask.

Mask Options:

Examples:

WorkWith "Finance.Transaction"
Format "Date", "Date"
Format "Price", "$"
Format "Qty", "#,0.0", "y"
End WorkWith