Combo box Number display Wrong

B

Brad

Thanks for taking the time to read my question.

I have a combo box to which I have this RowSource:
----
SELECT tblPriceList.PriceListNumber FROM tblPriceList, qryMaxPriceListNumber
WHERE
(((tblPriceList!PriceListNumber<>qryMaxPriceListNumber!MaxOfPriceListNumber)=True)) GROUP BY tblPriceList.PriceListNumber;
----

The query returns integers. NO DECIMALS. Perfect. However the combo box
apples 2 decimal places to the numbers when viewed through the combo box.
I've tried changing the format, the decimal places, tried saving the SQL as a
query and making the row source that query, but nothing works. Why do I have
the decimal places? I don't want them.

SQL returns

PriceListNumber
1
2
3

Combo Box returns

1.00
2.00
3.00

Thanks for your help,

Brad
 
T

tina

try changing your combobox RowSource to

SELECT Format(tblPriceList.PriceListNumber, "0%") FROM tblPriceList,
qryMaxPriceListNumber WHERE
(((tblPriceList!PriceListNumber<>qryMaxPriceListNumber!MaxOfPriceListNumber)
=True)) GROUP BY tblPriceList.PriceListNumber;

hth
 
B

Brad

Perfect! Thanks Tina. I understand what this does, but I don't understand
why I had to do this in the first place.

Thanks for the help.

Happy New Year,


Brad
 
T

tina

you're welcome :)
I understand what this does, but I don't understand
why I had to do this in the first place.
Click to expand...

well, me neither, frankly. that's just the way it is with combo box
droplists (and possibly with listbox controls, too, though i've never
checked it out).
 
Top