Data Entry

  • Thread starter Thread starter Eugene Stranney
  • Start date 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?
 
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.
 
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.




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top