In

Aaron said:

I am building some tables and forms in Access, and my numeric fields

are rounding to the nearest integer. I have the table field defined

as a Numeric and Auto for decimal places. I have the text box on the

form defined as a fixed with two decimal places. However, if I type

in 2.3453 it will round it to 2.00 or if I enter 3.5 it rounds it to

4.00. How do I get the text box to leave the value to accurately

round the number to whatever decimal place I have defined for the

field?

It sounds like the Field Size you've chosen for your field is Integer,

Long Integer, or Byte. These are all whole-number data types, and can't

hold decimal places no matter what format you pick. Change the field to

Single, Double, Currency, or Decimal, as appropriate for your use.

Single and Double are both floating-point types, which means they store

an imprecise representation of numbers, but their precision is high

enough for most purposes. If you need absolute precision to a certain

number of decimal places, you can use the Decimal type, but Access has

historically had a few quirks in handling fields of this type and I'm

not sure what the current status of the Decimal data type is.