Rounding numbers

[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

 

[pat \(removethis\)]

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

 

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

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.