As has been said is several spots, there is not an easy way (and maybe
not even a hard way) to place a google maps image on your form.
However, here is a very easy way to create a hyperlink to google maps.
This assumes a 2 line address in the form, but can handle a 3line
address with a name as well. Not sure how it would work with two
street lines.....
100 Hill Street
Chicago, IL 25184
Dim strLinkUrl As String ' address of provider passed to Google maps
in the URL
Dim strPath As String ' Google maps URL
Dim strAddr As String ' used to create address string
' this is the URL to Google maps
strPath = "http://maps.google.com/maps?q="
'For google search use the line below
'strPath = "http://www.google.com/search?q="
' convert any line feeds to spaces
strAddr = Replace(Me.Address, vbLf, " ")
'remove any double spaces
strAddr = Replace(strAddr, " ", " ")
'convert spaces to +'s
strAddr = Replace(strAddr, " ", "+")
combine with url
strLinkUrl = strPath & straddr
'open browser with link
Application.FollowHyperlink strLinkUrl
