decimal places

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

On Tue, 27 Jul 2004 09:22:09 -0700, "andrew"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public