In code, """" (four double quotes in a row) results in a one double quote.
Chr$(34) also results in a one double quote.

From the Immediate window (Ctrl-G)

?"""" = Chr$(34)
True


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"BruceM" wrote in message
...
I'm curious as to how Chr(34), which is as I understand it a double quote,
could substitute for a pair of doubled quotes. I have seen this
suggestion before, but I don't understand it.

"Sylvain Lafontaine" sylvain aei ca (fill the blanks, no spam please)
wrote in message ...
Each double quote delimited by other double quotes must be doubled:

If temp_word """" Then ...

You could also use Chr(34):

If temp_word Chr(34) Then ...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"00KobeBrian" wrote in message
...
I tried to write the following code in a module:

If temp_word """ Then

End If

But given syntax error. I want to check if the temp_word is equal to a
double quotation mark. How can I achieve this? Thanks.