ListBoxes and Commas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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 & """"
 
Back
Top