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?

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.

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


"Amanda" <(E-Mail Removed)> wrote in message
news:7F1DEDD8-5ED7-4526-8307-(E-Mail Removed)...
> 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?
>
>

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






"Amanda" wrote:

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

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

"Daniel Pineault" wrote:

> Does this happen when you are entering your value using a form or directly in
> the table?
> --
> Daniel Pineault
>
>
>
>
>
>
> "Amanda" wrote:
>
> > 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?
> >
> >

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

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Amanda" <(E-Mail Removed)> wrote in message
> news:7F1DEDD8-5ED7-4526-8307-(E-Mail Removed)...
> > 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?
> >
> >
>
>
>

Have you checked the Format property?

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

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

email address is invalid
Please reply to newsgroup only.



"Amanda" wrote:

> As I stated in my original message I have the field size set to double.
>
> "Douglas J. Steele" wrote:
>
> > 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.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no e-mails, please!)
> >
> >
> > "Amanda" <(E-Mail Removed)> wrote in message
> > news:7F1DEDD8-5ED7-4526-8307-(E-Mail Removed)...
> > > 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?
> > >
> > >
> >
> >
> >