I strongly advise NOT to use currency fields. I have used them and realized they don't work (at least not in my apps)
I calculate interest for govenment bonds and they were hundreds of Dollars off.
Changed the field type to N(17,2) and everything balances to the penny!
(My 2 cents (numeric 10,2))
Peter
>>I have my currency set as $ in the option menu of foxpro. However, when I browse some datafields, they come with 4 decimals. Same in my forms. Do I have to perform some SET CURRENCY stuff?
>
>Eric,
>
>Currency data type has fixed 4 decimals. If you want to only see 2 then you need to either use the ROUND() function or set the Inputmask to 999,999,999.99.
Peter Cortiel