Displaying digits after the decimal point

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amanda - 11 Jan 2008 13:09 GMT

In my table I have a field for quantity. I have the fieldsize set to double
and the decimal places set to 2. However it always rounds to a whole number.
For example when I put in 1.25 it rounds to 1....how can I make it display
the decimal points?

Reply to this Message

Douglas J. Steele - 11 Jan 2008 14:37 GMT

When you set the Data Type to Number, the default Field Size (bottom
left-hand corner) is set to Long Integer. Long Integers cannot hold decimal
values. Change the field size to Single or Double.

Signature

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

> In my table I have a field for quantity. I have the fieldsize set to
> double
> and the decimal places set to 2. However it always rounds to a whole
> number.
> For example when I put in 1.25 it rounds to 1....how can I make it display
> the decimal points?

Reply to this Message

Amanda - 11 Jan 2008 17:54 GMT

As I stated in my original message I have the field size set to double.

> When you set the Data Type to Number, the default Field Size (bottom
> left-hand corner) is set to Long Integer. Long Integers cannot hold decimal
[quoted text clipped - 6 lines]
> > For example when I put in 1.25 it rounds to 1....how can I make it display
> > the decimal points?

Reply to this Message

Dale Fye - 11 Jan 2008 19:03 GMT

Have you checked the Format property?

What happens when you change it to a Decimal rather than Double data type?

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> As I stated in my original message I have the field size set to double.
>
[quoted text clipped - 8 lines]
> > > For example when I put in 1.25 it rounds to 1....how can I make it display
> > > the decimal points?

Reply to this Message

Daniel Pineault - 11 Jan 2008 14:40 GMT

Does this happen when you are entering your value using a form or directly in
the table?

Signature

Daniel Pineault

> In my table I have a field for quantity. I have the fieldsize set to double
> and the decimal places set to 2. However it always rounds to a whole number.
> For example when I put in 1.25 it rounds to 1....how can I make it display
> the decimal points?

Reply to this Message

Amanda - 11 Jan 2008 17:53 GMT

It happens in both instances, whether I enter it through a form or through
the table it still does this.

> Does this happen when you are entering your value using a form or directly in
> the table?
[quoted text clipped - 3 lines]
> > For example when I put in 1.25 it rounds to 1....how can I make it display
> > the decimal points?

Reply to this Message