Hi

My field is just a standard n(11.2) field. I simply ticked the currency flag in the format for the field.

problem is resolved with "@$ 9,999.99" formating.

Regrads
Geoff
>>Hi
>>
>>On my report I have an invoice amount field. I put it on my report and it displays fine.
>>
>>I set the format to currency and all of a sudden I have copious quantities of decimal places displaying. What gives. Since when did the standard currency display need more decimals than two.
>>
>>I tried using
>>
>>

set decimals to 2

>>
>>but to no avail.
>
>Did you change the field type to Currency (Y)? If so, the data is stored as a BCD quantity with 4 decimal places; you need to alter the mask on the report form's field references, or convert the field to a Numeric for output using MTON(); Numerics respect the SET DECIMAL settings.
>
>Currency fields and variables have a nasty habit; if there is even a single Currency datatype in an expression, the type of the result of the expression becomes a Currency type. This can result in subtle rounding problems on multiplication, division and transcendental operations, different from those experienced by type N expressions. there are distinctive advantages to currency datatypes in addition and subtraction operations involving very large or very small quantities because of the BCD representation - the same advantages accrue to other math operations AS LONG AS NO INTERMEDIATE OR FINAL RESULT HAS > 4 DECIMAL PLACES OF PRECISION.