Difficulty Displaying Number Format In Tables

  • Thread starter Thread starter quirkyjoe
  • Start date Start date
Q

quirkyjoe

I start a new table.

I have values such as 1.03, 1.01, 1.00 that I want to put in there.

No matter what foramt I set for the fields, when i type 1.03 in the
datasheet view it is displayed as 1.00. Even if I set the format with
6 palces after the decimal it comes out 1.000000 when I type in 1.03.

Very annoying.

How to fix?

Thanks.
 
quirkyjoe said:
I start a new table.

I have values such as 1.03, 1.01, 1.00 that I want to put in there.

No matter what foramt I set for the fields, when i type 1.03 in the
datasheet view it is displayed as 1.00. Even if I set the format with
6 palces after the decimal it comes out 1.000000 when I type in 1.03.

Very annoying.

How to fix?

Thanks.
Click to expand...

You've got the numeric sub-type set to Integer or LongInteger which (by
definition) do not support fractional values. Change to Single or Double or
change the main type to Currency or Decimal.
 
Back
Top