I have a List Box with 4 columns,
And I insert the data with command
lst1.AddItem rst!col1 & ";" & rst!col2 ...(where rst is recordset)
If the rst!col1 will contain ";" (this specific character,for example "text1;text2" ) it will not work correctly.
How can I fix this problem