Rounding problems continue

[SAC]

Rounding is frustrating.

First, I have a table with currency field types.

I have a form based on the table.

When I click on the control formatted for currency I see more than 2 decimal
numbers. How can I eliminate this?

I have a checkbook that's off by 2 pennies(!) due to rounding problems. Now
it may be no big deal but the guy I work for thinks it is.

Is it pracrtical to think I can unload the data and reload it properly
rounded and it'll balance?

Concerning rounding...when should it take place? At the Record source level
using a query or at the form level. I'd think at the query level.

Then when I use code do I just insert the rounding function in the code?

Thanks for your help. This is frustrating.

 

[Guest]

When I click on the control formatted for currency I see more than 2 decimal

numbers. How can I eliminate this?

In form design view select the control. Right click and select Properties. I
use the Format and Decimal Places controls. I set the Format control to
"Fixed" and then enter whatever number of decimals I want in Decimal Places.
Do the same for your table.

As for the other stuff - I'm sorry but I can't help. Good luck!