why are my decimals rounding?

[Guest]

I'm working on a database with access 2000, and in one of my tables, I have
field in which I am displaying a monetary amount. I have it set to currency
format, and the decimal places set to auto (which is producing the obligatory
2 decimals). The problem is that whenever I enter an amount that includes
cents after the decimal, Access is automatically rounding it to the nearest
whole number.

For example, I enter $41.25, and access turns it into $41.00 when I move out
of that field.

What can I do to stop it from rounding to whole numbers and preserve the
entered amount?

Thanks in advance

 

[M.L. Sco Scofield]

Even though you are using the Currency "format," my guess is that the "data
type" of the field in the table is defined as an Integer or Long Integer.
You need to change the data type of the field in the table to Currency.

If this isn't the problem, post back with more information.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com