Combo box Number display Wrong

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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).
 
Back
Top