many decimal places in calculated fields

[GordS]

I'm working on a database that creates a report table and prints a report from it. When you go into this table and place the cursor on some of the fields, the number may expand to have 5 to 7 numbers after the decimal place even though it is defined as a a standard number with 2 decimal places. Does anyone know how to prevent this from happening?

[RuralGuy]

You could use the Currency DataType instead of a Single or Double. That limits it to no more than 4 decimals.