ListBox breaks to new line when adding Currency values to the list

L

Leo

Hello all. I have a simple line of code

List1.AddItem (rs("Totals"))


Totals is a currency field in the form of: $333,334.00

The problem is that the ListBox is breaking to a new line right after the
comma like this

$333
334.00

Can anyone help me out with a solution on how to show it all in one line
please?


Thanks a lot

Leo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a text box to search a listbox 0
Excel vba UserForm Lists not registering default values? 15
Selections in listbox change when subform is scrolled 1
Add comma during currency field entry 1
Userform Listbox highlights wrong line. 0
Problems when modifying a listbox 1
ADDING values from one listbox to another on same form 1
automation error 440 when adding to collection 8

Top