With amount mask, FormTrap formats the data by inserting a currency symbol and separators / decimal symbols. FormTrap determines whether the data is positive or negative by searching for these characters: -, Cr, CR, Dr, DR and ( ).

To apply Amount/Numeric masking:

• Create a new variable test object or edit and existing variable test object.
• On the Link to field dialog box, select Amount/Numeric form the Mask as menu.
• On the Input tab, select one of the following currency input types:
• Use decimal separator - FormTrap finds the decimal point in the field from the data and use this when formatting the value.
• Assume two decimals - the last two digits of the field will be used as the two decimals after the decimal point.

• On the Currency tab, select the currency symbol in the Representation menu. Delete the currency symbol to have no currency representation.
• On right - the currency symbol appears on the right of the masked value.
• Extra space - an extra space is inserted between the currency symbol and the masked value.

• On the Separators tab, select the separators for thousands and decimals.
• Thousands - select from a comma, full stop, space or have nothing to signify the decimal point.
• Decimals - select from a comma, full stop, space or have nothing to signify the decimal point.

• On the Numbers tab, select the credit symbol and the number of decimals.
  • Symbol - select the symbol used to indicate whether the value is a credit.
  • Extra space - check this box to insert a space between the value and the credit symbol.
  • Number of decimals - the number of decimal places used on the formatted value.

• Click the OK button to apply the mask to the field.

The price mask formats data fields using the selected price format. FormTrap will insert the correct currency symbol, hundreds and thousands separators and decimal separator for the selected region. The Price formats available are:

• American - ($1,234.56)
• British - (£1,234.56)
• German - (1.234,56 DM)
• Swiss - (SFr 1,234.56)
• French - (1.234,56 F)

To apply price masking:

• Create a new variable text object or edit an existing variable text object.
• On the Link to field dialogue box, select Price form the Mask as menu.
• Select the appropriate price format from the Output format menu.
• Select one of the following currency input types:
• Use decimal separator - FormTrap finds the decimal point in the field from the data and use this when formatting the value.
• Assume two decimals - the last two digits of the field will be used as the two decimals after the decimal point.

• Click the OK button to apply the mask to the field.

To apply wordy masking:

• Create a new variable text object or edit an existing variable text object.
• On the Link to field dialog box, select Wordy from the Mask as menu.
• Select the appropriate language from the Language menu.
• Select one of the following currency input types:
• Use decimal separator - FormTrap finds the decimal point in the field from the data and use this when formatting the value.
• Assume two decimals - the last two digits of the field will be used as the two decimals after the decimal point.

  More information on Word Wrap

This is especially useful when creating checks where the check amount is split into hundreds of thousands, tens of thousands and so on. In the example below, you need to define each character of the input data separately.

To apply units masking:

• Create a new variable text object or edit an existing variable text object.
• On the Link to field dialog box, select Units from the Mask as menu.
• Select the appropriate language form the Language menu.

To Apply cents masking:

• Create a new variable text object or edit an existing variable text object.
• On the Link to field dialog box, select Cents from the Mask as menu.
• Select the appropriate language form the Language menu.
• Select one of the following currency input types:
• Use decimal separator - FormTrap finds the decimal point in the field from the data and use this when formatting the value.
• Assume two decimals - the last two digits of the field will be used as the two decimals after the decimal point.