How do I stop Access from displaying rounded numbers?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fromethius - 14 Apr 2005 21:30 GMT

When I enter a number with decimal places on my form, they are displayed as
whole numbers on my table. I have tried various number formats and decimal
place settings.

Reply to this Message

rowiga - 14 Apr 2005 21:43 GMT

Check the Field Size property of the field in the table and make sure that it
isn't integer.

> When I enter a number with decimal places on my form, they are displayed as
> whole numbers on my table. I have tried various number formats and decimal
> place settings.

Reply to this Message

Ofer - 14 Apr 2005 21:44 GMT

try to declare your number as double

> When I enter a number with decimal places on my form, they are displayed as
> whole numbers on my table. I have tried various number formats and decimal
> place settings.

Reply to this Message

fredg - 14 Apr 2005 22:43 GMT

You have incorectly set the field datatype to Number Field Size Integer or
Long Integer. By definition, an integer is a whole number and cannot have a
decimal value.
Either change the change the Field Size to Double or change the datatype to
Currency

Reply to this Message