Don't delimit on commas in row source

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

Guest

I'm filling a list box on a form with the variable strFill.

strFill = "Apparel, Clothing & Textiles; Food and Drug; Food, Beverage &
Tobacco..."

And on up to about 50 items.

The problem - I thought the list box would contain the 50 items separated by
semi-colons, but in fact, the comma appears also to be delimiting the
results. So "Apparel" is separate to "Clothing & Textiles".

Any advice would be appreciated.

Daniel
 
I don't have a clue where your strFill is coming from but you could try
include quotes:
strFill = "'Apparel, Clothing & Textiles'; 'Food and Drug'; 'Food, ...'
 
Back
Top