I made an update query that generates a google maps url link in a hyperlink type column based on the address in other columns. When I click on the generated link it works and opens my browser to the address in google maps but after I close & reopen access it doesn't work anymore even after using the query again, it acts like normal text but the url is underlined and the pointy finger shows. I'm guessing the function that determines if a string is a url is looking at the code instead of the result of the code . I am using access 2007 btw.
UPDATE Property SET Property.Notes = "https://maps.google.com/maps?q="+Replace(Nz([Park Address],"Address")," ","+")+",+"+Replace(Nz([Park City],"City")," ","+")+",+"+Replace(Nz([Park State],"State")," ","+")+",+"+Replace(Nz([Park Zip],"")," ","+");