ListBoxes and Commas

[Guest]

When I try to add a string to a listbox using the AddItem method, it automatically parses the comma in the string. Is there any way around this short of removing the comma? It is fairly important that the field be allowed to include commas, both for ease of use and because I need the official entity name for tax purposes.

Please Help!

 

[Sandra Daigle]

Hi Elizabeth,

Try wrapping the value in quotes before you add it:

Me.List0.AddItem Chr$(34) & Me.Text2 & Chr$(34)

or

Me.List0.AddItem """" & Me.Text2 & """"