Format Problem In Combo Box

[sdimaggio]

I have a PricingTable with two fields:

Field1: Pricing Code (formated in Text)
Field2: Price (formated in Currency, 4 decimal places)

My problem is that when I make a form and place a combobox on the form for the Price field and then click the pulldown triangle it will only display 2 decimals in the Price column and not 4 in order to make a selection.

My combobox is not formated but accepts the Price Code which is text. I checked the row source in the properties section of the combobox and ran the query and it shows 4 decimals. I widened the column width as well in the properties section for the Price field and still no luck.

I also formated the combobox as currency, 4 decimals (even though it is a text data input) but that did not work either.

Any Ideas?

Steve

 

[pdldavis]

Hi, what I do when working with an unusual number of decimal places is in the query for the combo box, instead of using the usual field 'Currency' as a row source - use a string expression. If 'Currency' is the field you want to reference in your combo box, replace with:

expr: Left([currency],8) - where [currency] is the name for the field in your table.

The combo box will display the text string with the four decimal places. If you want to display a $ sign too, then it would be:

expr: "$"&left([currency],8)

Hope that helps.

 

[sdimaggio]

Clever trick.

Thanks

Steve