Folks,

I am trying to populate a list box with a value list. Unfortunately, one of the values has a comma in it. The comma causes the word trailing it to drop down to the next line. The four values are:

2-Propanol
Isopropanol
Isopropyl Alcohol
Isopropyl alcohol, anhydrous

If I place these in a string and use as the row source, it appears in the list box as follows:

2-Propanol
Isopropanol
Isopropyl Alcohol
Isopropyl alcohol
anhydrous

Any help you can provide is appreciated.

Thanks,

MikeCJ

Try surrounding the offending value with "Isopropyl alcohol, anhydrous".

The Access help files may have a better or even the correct answer.