Number Formats HELP?

[Adam]

I have a field on a form that i want to be able to enter a number in decimal
format and keep it exactly the way i enter it (ex: 155.5). However the field
is automtically rounding the number off to 156 or 155. I've played around
with a few format combinations but it continues to round the numbers - Any
suggestions???

 

[Al Campagna]

Adam,
What we need to consider is what value is stored in your table vs. what
value is shown on the form.

That's probably due to the type of numeric field that you defined in
your table design.
Byte, Integer, and LongInteger can not take a decimal value (whole
numbers only)
Single and Double can take a decimal value.
Try setting that field in the table to Numeric/Single with 1 decimal
place.

If your table shows 155.5, and the form shows 156, check your formatting
on the form.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Douglas J. Steele]

When you created the field, I suspect you selected Number from the list of
available data types, and didn't look in the bottom left-hand corner at the
Field Size property. By default, Access makes all numeric fields Long
Integers, and integers, of course, cannot have a decimal portion.

Go back into the design mode and change the Field Size to one that can
accept decimals (Single, Double or Decimal)