Amount field

Amount field is an option that you can select when defining character fields on a form definition. In the Field dialog, click the Options tab.

Use this option on fields containing numbers (typically monetary amounts) that contain a decimal, where the decimal and zeros can be safely added when a non-decimal number is entered in Verify.

When FORMS interprets a whole number where a decimal was expected, you must still check the field (using Verify) to make sure that an existing decimal was not missed. However, you must no longer type the missing decimal and zeros. You can simply click OK or press Enter if the field value is correct.

Example:

The format is N(3-4).N(2) and the interpreted field value is "127".

The field receives the status Validation error and is displayed in Verify. If you confirm the value, it is changed to 127.00 without you having to type in the decimal and zeros. It is also changed to 127.00 if you enter any of the following as the field value:

127 127,0 127,00 127.0 127.00

The field value transferred by the system is either 127.00 or, if Pad decimals with zeros was also selected as an option, 12700.

This option cannot be selected if Alpha, lowercase, Alpha, uppercase, Special characters, Space, or Multiple lines is selected in the Format group box. In addition, multiple possible formats may not be specified.

Note: When you indicate a decimal in the format specification, you can improve interpretation by specifying the position of the decimal.

Options for character fields

Specifying the position of a decimal in a character field

Specification of character, object and data fields