Automatic rounding?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Skorpian - 30 Apr 2005 08:23 GMT

Can someone please tell me how to disable automatic rounding on percentage
fields? In both table and form view (the field is set to number, percent,
long integer, 3 decimal places), any value I enter into this field is
automatically rounded to the nearest 100%.

I've looked in tools->options, searched the helpfile for rounding, but was
unable to find anywhere to disable this.

Thanks
PS. Using Access 2002

Reply to this Message

Ed Warren - 30 Apr 2005 11:27 GMT

Try using a double (value with decimal part) rather than an integer (whole
number) , it will work better.
also you need to enter percent as a decimal value e.g 0.50 --> 50%

Ed Warren

> Can someone please tell me how to disable automatic rounding on percentage
> fields? In both table and form view (the field is set to number, percent,
[quoted text clipped - 6 lines]
> Thanks
> PS. Using Access 2002

Reply to this Message