Don't delimit on commas in row source

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
 
D

Duane Hookom

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, ...'
 

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

Commas in list box items 10
Excel VBA - Force 4 commas into a text field on userform 7
Use of commas in form controls and tables 2
Join on field that contains multiple items 3
How can I duplicate the form data? 2
How may I use the IN operator when using a RowFilter on a DataView? 1
Deleting text in a combo box to delete row in N:N table 4
Package-in-a-package problem 5

Top