Topics

Using R5, a developer can create applications which manipulate more than one currency, including the euro, and these currency values and symbols are independent of the locale setting or operating system default currency symbol.

When creating a form, a currency field is defined using the Field Definition Infobox. One step in the currency field definition is to choose the currency symbol. Once chosen, the currency symbol and the currency amount always display together in that field.

In R5, displaying a currency field value in a view must be approached differently. For a view column to display a currency field, use a view column formula similar to the following example for displaying Japanese Yen in a view:

@If(JapaneseCurrencyValue!="";"¥"+@Text(JapaneseCurrencyValue;"F,2");"")

where "JapaneseCurrencyValue" is the name of a form field and "F,2" is a format string that establishes a fixed format with 2 digits of precision.