I am filling a listbox with a recordset using sql. The problem is one field sometimes has a comma in it and the sql splits it into two fields, which then messes up the listbox.

"Soupy Sales" works fine, it is all in one field.
"Sales, Soup" does not, it needs room to spread out.

Unfortunately the field contents cannot be changed.

Thanks.

ScottP

__________________
ScottP

What is the SQL statement?

mmcdonal

After further research I realized it is not the sql statement, it is the way the listbox handles the data coming in. The listbox takes all commas and semi-colons and splits the data into two or more cells.

ScottP