Access Listbox Problem

[Tony]

I have a problem with access listboxes. The data I wish to
display contains all sorts of characters including ,
and ;. Is there a way I can set a custom row seperator? As
my records are being seperated on multiple lines when
actually it's just one record.

Regards,

Tony

 

[Nikos Yannacopoulos]

Tony,

If the data you are displaying came from a table field then it would display
just fine regardless of the colon and comma characters, so I suppose it's
data you typed manually in the listbox's RowSource property, right? In that
case, just enclose each intended row datum in (single or double) quotes and
separate as usually, and the rows will be displayed as intended.

HTH,
Nikos