Passing a quotation mark to a select string from macro

[#1]

I am trying to create a button to automatically select a couple items from a field.  If I were to just type in the select string it would be :"AF  "|"N   "|"MC  "|"A   ".  However I can't pass the quotes in the macro.  I have tried multiple things, such as """ to get around it, but nothing is working.  Any suggestions?

Thanks in advance,

Therese

[tanelry · Accepted solution]

Use chr(34) in macro

v = "(" & chr(34) & "AF " & chr(34) & "|" & chr(34) & "N " & chr(34) & ")"
ActiveDocument.Fields("FieldName").Select v

If you use QV10 then better assign "select in field" action for button instead of macro,

with static select string as ("AF "|"N ")

or calculated as ='(' & '"AF "' & '|' & '"N "' & ')'

[#3]

Thanks...  I had actually gotten to there a couple days ago, but had my quotes in there wrong.  I didn't realize until I had it set a variable as the string I created. 

Thanks!