A2003: Combo box column only shows 3 decimals (1 Viewer)

[bulrush]

A2003 on Win XP

Fieldname: Cost
Fieldtype: currency (this may be my problem)
Decimals: 3

I have a table with a field called "cost". In the table def the Decimals property says "3". I have a combo box on a form which is used as a Search box, so it is not bound to anything. But the RowSource property of the combo box uses the Cost field. When I run the form and drop down the combo box, the Cost column rounds to 2 decimals.

How can I get the Cost column to show all 3 decimals as specified in the Table def?

Thanks.

p.s. This is a dollar amount for buying larger quantities of an item, but I might have to change it to a Single field type to show 3 decimals.

 

[bulrush]

Yes, that was it. Cost field was changed to a type of Single, and 3 decimals. It shows up correctly in the combo box now. But on the form I can change the Format to Currency, which shows the dollar sign plus 3 decimals. Which is what I want.