decimal places get rounded

A

Annoyed

No matter what property and format I use, when I enter a
number with a decimal (3.33) it gets rounded
(to 3.00). I can't find a property that will allow me to
do this.

HELP!!!
 
D

Dirk Goldgar

Annoyed said:
No matter what property and format I use, when I enter a
number with a decimal (3.33) it gets rounded
(to 3.00). I can't find a property that will allow me to
do this.

HELP!!!
Click to expand...

You probably have the field's Field Size property (in the table design)
set to Long Integer or Integer. Integer fields by definition are whole
numbers and cannot store decimal places. Use Single, Double, or (if
appropriate) the Currency data type instead.
 
G

Guest

been there and been equally annoyed. there is a solution,
it is just a "simple" matter of working the problem.
starting with your table format, working through the
formats on your form, and the formats of any VB code you
might be running. start over from the beginning, make
sure you have your Format and Decimal Places properties
set correctly in the Table as well as your Field's
Properties on your Form. working with a set number of
decimal places can sometimes be tricky in Access. one
incorrect setting and it will usually either round up on
you or give you the infinite number of decimal places.
 
Top