Format ? on ListBox Ctrl Source 2

[Dylan]

I have a List Box with a control source that lists a merchant number in my application.
This control src is defined as Number(long integer) in my db. (The row source is a query)

My problem is " the merchant nbr displayed in my list box appears with 2 decimal places. ex 591432.00 (instead of 591432 whcih is what I want displayed)

Is there a way to chg the formatting of this displayed fld ???

Thanks Much for Any assistance ...

Tom Moran
Lansing, Michigan

 

[LJtechnical]

Hi Tom

In the decimal places properties change from auto to 0.

LJT

 

[Dylan]

Hi LJT,

There is no dec place prop for the List Box. I did verify that the merchant nbr in the db tabel is set to 0 dec places and format of Fixed.

tom

Tom Moran
Lansing, Michigan

 

[PHV]

Have you tried to use the Format function in the RowSource ?
SELECT Format([merchant nbr], '#') FROM ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Dylan]

Thanks PHV That worked ...


Tom Moran
Lansing, Michigan