decimal places

[andrew]

Hello all!
I'm trying to get my table to show decimal values.

In the table design view, I set "Field Size" to decimal,
and Decimal Places to "4". However, all the decimal
values I enter still get truncated.

The help section said to look at the "Property Sheet."
This is the property sheet, right?

Thanks in advance!
Andrew

 

[John Vinson]

Hello all!
I'm trying to get my table to show decimal values.

In the table design view, I set "Field Size" to decimal,
and Decimal Places to "4". However, all the decimal
values I enter still get truncated.

The help section said to look at the "Property Sheet."
This is the property sheet, right?

Look first at the top row of the property sheet. I suspect it has the
default Number datatype, Long Integer. An integer, BY DEFINITION, is a
whole number.

Change it to Float or Double. I don't recommend using the Decimal
datatype, it's buggy. If you need exactly four (no more, no fewer)
decimal places, don't use a Number datatype at all - use a Currency
datatype instead.