Escape codes for delim characters in listbox value list?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 09 Feb 2006 23:37 GMT

Hello.

I am using an Access listbox with RowSourceType set to "Value List."
Some of the values that I want to add to the list contain characters that
are interpreted as list delimiters when I set the RowSource property.
I have tried replacing the offending literal characters with every
escape sequence that I can think of. . .nothing works.

Suggestions?

Thanks
-Mark

Reply to this Message

cjb_kjb - 10 Feb 2006 01:09 GMT

The delimiter for values in a value list is ";".
Include the values in quotes
i.e.
"aaa;";bbb;"u;pp"

gives a list:
aaa;
bbb
u;pp

Reply to this Message

Mark - 10 Feb 2006 01:36 GMT

> The delimiter for values in a value list is ";".
> Include the values in quotes
> i.e.
> "aaa;";bbb;"u;pp"

That fixed it. Thanks!
-Mark

Reply to this Message