ListBox AddItem Error

[Pete]

I am having a problem with the ListBox AddItem function
not working properly. See below:

strItem ="Clin Path;Haem, Bio & retics;HB&ret"
Me!lstProcedure.AddItem Item:=strItem

The problem appears to be due to the comma in the string.
AddItem is supposed to use the semi-colon as the
delimiter character, but the comma is also acting as a
delimeter. How can I add text that contains commas?
Thanks

Peter

 

[Larry Linson]

Simplest solution: remove the commas. In the example you
give, that would not appear to affect the readability.
ListBox lists shouldn't have to have picture-perfect
punctuation. Alternative: replace the commas with "/"
or "|" or "-".

Unfortunately, I am not in a position to try some other
alternatives just now.

Larry Linson
Microsoft Access MVP