Currency Field

[istevens]

I have a currencty field on a form which displays the price of various products. The problem is if a product is $100.51 it rounds up to $101 on the form I want to display the correct price ($100.5) on the form. Why is it being rounded up?

Thanks

Ian

 

[SoloDroid]

Hello Ian,
This sounds like you have the text box field properties set to "General Number" with "0" decimal places. You should select "Currency" with "2" decimal places.
Good Luck, Robert
•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•
Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com

°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°

 

[RangerFan]

Hi Ian,

Try this. Go to the field on the form that is rounding up your currency amount. Right click on the field, and then click on properties. Check the Decimal Places property. If it is set to 0 then that is probably the problem. Set Decimal Places to either Auto, or a specific number such as 2.

I just tested this theory, and with Auto my total was $103.97, and when I set Decimal Places to 0 I got $104.

Try this. I hope that it works.