decimal places

[Ruth]

Hi

I have changed the number of decimal places to 2 in the database and in on
the form and the decimal places still does not show. I tried to enter
numbers with decimals directly in the database and on the form and the result
is the same, each round up to the nearest whole number. What do I need to
do?

 

[Dirk Goldgar]

Hi

I have changed the number of decimal places to 2 in the database and in on
the form and the decimal places still does not show. I tried to enter
numbers with decimals directly in the database and on the form and the
result
is the same, each round up to the nearest whole number. What do I need
to
do?

Make sure that the Field Size of the field in question is not one of the
whole-number types: Integer, Long Integer, or Byte. Those types can't
store any decimal places, by definition. Use a Field Size of Single,
Double, or Decimal, or a Field Type of Currency, to allow decimal places to
be stored.

 

[Ruth]

Thank-you very much!
--
Thank-you!
Ruth

Make sure that the Field Size of the field in question is not one of the
whole-number types: Integer, Long Integer, or Byte. Those types can't
store any decimal places, by definition. Use a Field Size of Single,
Double, or Decimal, or a Field Type of Currency, to allow decimal places to
be stored.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)