ConvertFieldToCurrency

Converts the value of the current field to a currency value.

Syntax

bool ConvertFieldToCurrency ()

Smart parameters are supported.

True if the text value is numeric and greater than one character. Otherwise, False.

All levels, but generally applied at the Field level.

Formats the text value of a field as a currency value. The following steps are performed on the field:

Removes existing currency symbols.
Replaces negative value characters such as parenthesis, 'NEG', 'CR' and trailing hyphen with a leading hyphen.
If a decimal exists, its position is not changed.
If a decimal does not exist and the field contains 2 or more characters, a decimal is inserted before the last two characters in the field.
If a decimal does not exist and the field contains less than 2 characters, no decimal is inserted.

Example

ConvertFieldToCurrency()
A value of 1  remains 1
A value of 12  becomes .12
A value of 105  becomes 1.05
A value of 104.009  remains 104.009