Number Formats HELP?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 17 Mar 2008 15:17 GMT

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

Reply to this Message

Al Campagna - 17 Mar 2008 15:28 GMT

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.

Signature

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."

>I have a field on a form that i want to be able to enter a number in
>decimal
[quoted text clipped - 3 lines]
> with a few format combinations but it continues to round the numbers - Any
> suggestions???

Reply to this Message

Douglas J. Steele - 17 Mar 2008 15:30 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message