Stop Rounding Currency

[Brinker1975]

In my table, I have two fields set to Currency with 6 decimal places. It's
rounding my decimals to the fourth place.

Why would it allow for 15 decimals if it's just going to show zeros for the
rest?

What settings do I need in order to have my decimals displayed as typed, and
have a dollar sign added?

 

[Rick Brandt]

In my table, I have two fields set to Currency with 6 decimal places.
It's rounding my decimals to the fourth place.

Why would it allow for 15 decimals if it's just going to show zeros
for the rest?

What settings do I need in order to have my decimals displayed as
typed, and have a dollar sign added?

Um, the Currency DataType only allows for four decimal places if you check
the help file. For more than that you would have to use a Single or a
Double or the new (and problematic) Decimal type.

 

[Dirk Goldgar]

In my table, I have two fields set to Currency with 6 decimal places.
It's rounding my decimals to the fourth place.

Why would it allow for 15 decimals if it's just going to show zeros
for the rest?

What settings do I need in order to have my decimals displayed as
typed, and have a dollar sign added?

The Currency data type only holds 4 decimal places. The Decimal Places
property is a formatting option, and can apply to many different numeric
types, so it isn't limited to what the Currency type supports.

If you want to hold 6 decimal places, you can't use the Currency data
type. You could use Single or Double, but they have the disadvantage of
not being precise types, the way Currency is. Or you could use the
Decimal data type, but as the newcomer among supported data types, it
suffers from some bugs in its handling, which may or may not have any
impact on you. For either of these options, you could still apply the
"Currency" *format* -- not data type -- to have it displayed with dollar
signs and decimal places.