Rounding numbers

M

Mike

I have a table with a field called [Rate]. It is formatted
as a fixed number with 5 decimal places. Everytime I enter
a number, it automatically rounds the number to the next
highest or lowest digit. I would like it to not round off.
What do I need to do?
Thanks
 
P

pat \(removethis\)

Try changing to automatic, instead of fixed, and use an
input mask to constrain data entry on the form to 5 digits.
 
J

John Vinson

-----Original Message-----
I have a table with a field called [Rate]. It is formatted
as a fixed number with 5 decimal places. Everytime I enter
a number, it automatically rounds the number to the next
highest or lowest digit. I would like it to not round off.
What do I need to do?
Click to expand...
Click to expand...

The default Number datatype is a Long Integer - and an Integer, by
definition, has no decimal places.

Change the datatype of the field to Double.
 
Top