Exact Match Hyperlink

[JeffG3209]

I use hyperlinks to search the internet for various information on my form.

="http://www.google.com/search?q=" & [FULL NAME] & " " & [CITY]

I usually end up having to manually modify my Google search like this. "Susan Jones" Dallas Texas

If I don't do this I will get a ton of other Jones names that are irrelevant. Is there anyway to add the "" to a search around a field?

I have tried "[FULL NAME]", but that obviously will not work.

[pbaldy]

This is a shot in the dark, but try

="http://www.google.com/search?q='" & [FULL NAME] & "' " & [CITY]

If that doesn't work try

="http://www.google.com/search?q=" & Chr(34) & [FULL NAME] & Chr(34) & " " & [CITY]

[JeffG3209]

="http://www.google.com/search?q=" & Chr(34) & [FULL NAME] & Chr(34) & " " & [CITY]
Nada

="http://www.google.com/search?q='" & [FULL NAME] & "' " & [CITY]
Result = 'Susan Jones' HOUSTON
Very Close! Can I add two apostrophes somehow?

[pbaldy]

What did the first one return? Chr(34) is the double quote ("), so that should have worked. In a brief test this:

="http://www.google.com/search?q=" & Chr(34) & "Paul Baldy" & Chr(34) & " Vegas"

resulted in:

http://www.google.com/search?q="Paul Baldy" Vegas

I suppose you can try

="http://www.google.com/search?q=""" & [FULL NAME] & """ " & [CITY]

Tripling up on the quotes I think makes it return a single.

[JeffG3209]

="http://www.google.com/search?q=" & Chr(34) & [FULL NAME] & Chr(34) & " " & [CITY]

It's not opening the browser. I can see the form working pointer icon when I press the link though.

[JeffG3209]

Figured it out. Hope this helps the next guy.

The correct syntax for using "anything" is %22anything%22.

http://www.google.com/search?q=%22anything%22+[your field name]