How to escape separator in multi column comboboxes?

[jbenezech]

Hi All,

I have a piece of code that adds items to a multicolumn combo box. I understand that the column separator is ";". So I coded like this:

'this adds 1 row with 2 columns OK
myCombo.addItem "1;Village"

This works fine until I get ";" character in the value of one of the columns.

'this adds 2 rows NOT OK
myCombo.addItem "1;Vill;age"

Does anybody knows how to escape the ";" character so that it is not considered as a column separator ?

I tried escaping with " , \ ' but didn't work

I noticed that I don't get the problem if I use "," as column separator but I read in other posts that I should use ";".

Cheers,
Jerome