Quoted "word" in combo RowSource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 23 Jun 2007 06:09 GMT

In the RowSource of a combo box that uses fixed
text strings per line, how does one specify a quoted
word?

Example:

"Line 1";"Line 2";"I want to have a quoted "word" here"

I've tried """word"""

and

"I want to have a quoted" & """word""" & "here"

I didn't try to set the line in code at runtime, as it would
seem to me that with my last example that would probably
be a waste of time?

Reply to this Message

Bill - 23 Jun 2007 06:11 GMT

For the time being, I used two single quotes with
success and the desired results. But, it would be
nice to know how to do it correctly.
Bill

> In the RowSource of a combo box that uses fixed
> text strings per line, how does one specify a quoted
[quoted text clipped - 13 lines]
> seem to me that with my last example that would probably
> be a waste of time?

Reply to this Message

Allen Browne - 23 Jun 2007 07:44 GMT

Try:
"I want to have a quoted ""word"" here"

Explanation:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> For the time being, I used two single quotes with
> success and the desired results. But, it would be
[quoted text clipped - 18 lines]
>> seem to me that with my last example that would probably
>> be a waste of time?

Reply to this Message