Automatically Populate Bing Maps URL From MS Access

[DoulgasPost]

I have a form that contains the following fields:

• Address
• City
• State
• Zip

I convert this to FullAddress with:

Dim FullAddress As StringFullAddress = Address & " " & City & " " & State & " " & Zip

I am outputting to Outlook and want to create a link to Bing Maps with:

"<br><A HREF=http://www.bing.com/maps/?v=2&where1=" & FullAddress & "&sty=b>Bing Maps</A>"

Somehow the A HREF function truncates the string to the first space contained in the FullAddress. So if the address read "5822 Cranston, Portage, MI 49002", the actual output hyperlink is: http://www.bing.com/...v=2&where1=5822 Instead of what I want it to do which is : http://www.bing.com/maps/?v=2&where1=5822 Cranston, Portage, MI 49002 &sty=b I realize that HREF may not like spaces but my field Address has the street number and address in the same field instead of separate fields.