Declaring Double Quotes in a String Value

[Bob1912]

I need to use the below string in an Access 2002 function so my code will perform an auto-replacement loop. The problem is the string : (“Program” NOT Available) : will not compile because of the double quotes. I have tried []'s, strquote = Chr$(34), extra double quotes, wildcards and I cannot seem to get anything to work. I would appreciate any assistance or pointing me in the right direction. Thanks.

 

[FancyPrairie]

Not sure what you are trying to do. If you want a message box to display: "Program" not available where the double quotes are displayed as part of the message, then it should look like this:

msgbox """program"" not available"

 

[AvGuy]

Usually a double quote (&quot signals the beginning or end of a string or SQL statement. If you want to reference a literal inside the double quotes try using an apostrophe (') around the literal, e.g.

DoCmd.RunSQL "SELECT * FROM table WHERE table.key = 'fish'"

AvGuy

 

[PWise]

try "(" & chr(34)& "Program" & chr(34)& " NOT Available) :"

 

[Bob1912]

Thanks for all the responses, pwise was the one I needed. I could have sworn I had tried that one before. Thanks again for all your help.