How to stop number rounding

  • Thread starter Thread starter Jan Il
  • Start date Start date
J

Jan Il

Hi All :-) - Access - XP Pro

I have a field to record parcel acreage. However, no matter what data type
is selected, the field continues to round the entry to the next whole
number. How do you stop a field from rounding a number?


Jan :)
MS MVP - IE/OE
Smiles are meant to be shared,
that's why they're so contagious.
 
Hi Duane :-)
Have you tried setting the field type to Numeric-Double or Single?
Click to expand...

Have tried the single, but, will try the single but, will try the double

Thank you very much for your time and help. I really appreciate it. :-)

Jan :)
MS MVP - IE/OE
Smiles are meant to be shared,
that's why they're so contagious.
 
In the DB you need to clear the table definition Precision column in the
table. Just set it to zero and the data will allow it to not round. If
the precision is set to high then it will round.
 
In the DB you need to clear the table definition Precision column in
the table. Just set it to zero and the data will allow it to not
round. If the precision is set to high then it will round.
Click to expand...

I think the right answer was actually to change the data "size" to a
floating point number such as Single or Double, rather than the default
integer.

B Wishes


Tim F
 
Back
Top