Rounding numbers

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
Try changing to automatic, instead of fixed, and use an
input mask to constrain data entry on the form to 5 digits.
 
-----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.
 
Back
Top