VBA - Search Google

[QandAdam]

I have the following code which triggers when the user double clicks on a field:

[/COLOR][COLOR=#000000]Application.FollowHyperLink "http://www.google.co.uk/search?q=" & BusinessName[/COLOR][COLOR=#333333]

This works fairly well and opens Google to search for the value in the BusinessName field. However, some Businesses contain "&" - which causes issues... The Google search only returns the text prior to the "&". Is there a way to include all of the field?

E.g.
Business Name = Jack & Jones
Google Search = Jack

 

[Joe4]

I think you need to replace all the "&" in your BusinessName field with "+".
You should be able to do that with the Replace function.
See: https://www.techonthenet.com/access/functions/string/replace.php