Opening a Google map from address in a form

[Paul]

Is there a way to open a Google map using an address string in a form?

Thanks in advance,

Paul

 

[Mr. B]

Hi, Paul.

Yes, you can open a Google map usisng a address string from a form.

You can use the followin code in the After Update event of a command button:

Dim strAddress As String
'read the Address and assign it to a string type variable
strAddress = Me.txtAddress
Application.FollowHyperlink "http://maps.google.co.uk/maps?f=q&hl=en&q=" _
& strAddress & ""

You will need to change the "Me.txtAddress" to the name of the control (text
box) that has the address that you want to display on a Google map.

 

[Paul]

Mr. B: - it works!

Thanks so much.

Paul