Automatic rounding?

[Guest]

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

 

[Ed Warren]

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