List Box Format Question

[splint1906]

I have a list box on a form who's rowsource is one of three queries (based on the user selection). My problem is the field formats in the listbox do not match the formats of the undelying queries. My part #s are showing up with 2 decimal places. Is there a way to set the format of each column in the list box via code or some other means?

 

[PHV]

Have you tried Format(PartNumber, "0") As PartNumber in the relevant query ?

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

 

[splint1906]

PHV,

When I execute the underlying query, the resuls are formatted correctly. However, when I execute the form and the listbox is populated, the results are wrong (part #s show decimal places).