Data Entry

  • Thread starter Eugene Stranney
  • Start date
E

Eugene Stranney

I am entrying data into a table via a form. I have set the
properties to "Number";"Standard" and the decimal places
to "2".

But no matter what I do both in the form and the table
Acess keeps rounding. What am I missing Here?
 
M

Mark

Check the field properties in table design. The Number data type defaults
to size of Long Integer, which only allows whole numbers. You should change
it to Single, Double, or Currency.
 
E

Eugene

Many thanks works a treat
-----Original Message-----
Check the field properties in table design. The Number data type defaults
to size of Long Integer, which only allows whole numbers. You should change
it to Single, Double, or Currency.




.
Click to expand...
 
Top