Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to format a currency fields ?
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00294286
Message ID:
00296317
Views:
26
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform