Formatting a Listbox column

[aziz rasul]

In a table I have a numerical field called [rowcount] with

Field Size = Long Integer
Format = Standard
Decimal Places = 0

I use a query based on the table as the record source of a listbox to select some of the fields.

When I open the query, the [rowcount] column appears as it is set in the table e.g.

64,000

However in the listbox it appears as

64,000.00

How do I resolve this?

 

[vbaInet]

Have a look at the Format property of the listbox. There's a numerical formatting set.

 

[JamesMcS]

Can you use the format command in the control source of the listbox? As in

=format ([rowcount],"#,##")

 

[aziz rasul]

Didn't understand vbaInet?

Tried what you suggested JamesMcS, but still gave me the same result.

BTW [rowcount] is the 3rd column in the listbox.

 

[JamesMcS]

Try putting it in the row source statement, sorry, not used listboxes before. So

SELECT format([rowcount],'#,##') AS Row_Count....

 

[vbaInet]

Hmm... Had a think there. A listbox doesn't have the Format property does it? But a combo box does. In that case, try casting your value to a String in your query - CStr()

 

[aziz rasul]

The SELECT statement worked. Thanks.

vbaInet I tried your suggestion but no luck, but thanks for your input.

 

[JamesMcS]

Good stuff, glad it worked!