How to stop number rounding

[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.

 

[Duane Hookom]

Have you tried setting the field type to Numeric-Double or Single?

 

[Jan Il]

Hi Duane

Have you tried setting the field type to Numeric-Double or Single?

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.

 

[mstrangis]

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.

 

[Tim Ferguson]

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.

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