Double Quotes Question

A

Angela Hunt

I forgot - what is the trick to displaying a double quote (") in the text field? I thought it was /" but of course I was wrong. Thank you.
 
D

Douglas J. Steele

2 double quotes in a row, or Chr$(34).

To get

This is Doug's "response"

you'd use:

"This is Doug's ""response"""

or

"This is Doug's " & Chr$(34) & "response" & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Angela Hunt said:
I forgot - what is the trick to displaying a double quote (") in the text
Click to expand...
field? I thought it was /" but of course I was wrong. Thank you.
 
N

Norman Yuan

You mean in VBA code, right?

Double the quote mark:

If you want to see : This is "test". in text box, or message box, you do

txtBox1="This is ""test""." or
MsgBox "This is ""test""."

Angela Hunt said:
I forgot - what is the trick to displaying a double quote (") in the text
Click to expand...
field? I thought it was /" but of course I was wrong. Thank you.
 
Top