Jump to content

Access not recognizing hyperlinks


equicidal
 Share

Recommended Posts

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],"")," ","+");

Edited by equicidal
Link to comment
Share on other sites

If I change the column type to text then back to hyperlink it works, but the link will get cut off since text type columns can only hold so much. Maybe the links are just too long, is there a way to force the column to accept large links? or shorten links bitwise without losing data?

Link to comment
Share on other sites

I'm not that familiar with Access, if "hyperlink" is actually a valid data type for a column then you might be able to change the size of it similar to any other text column. There's some more information here: http://blogs.office.com/b/microsoft-access/archive/2008/01/09/using-hyperlinks-in-access-display-as-hyperlink-and-is-hyperlink.aspx

Link to comment
Share on other sites

I'm not that familiar with Access, if "hyperlink" is actually a valid data type for a column then you might be able to change the size of it similar to any other text column. There's some more information here: http://blogs.office....-hyperlink.aspx
Thanks but I figured it out. I had to change the column type to text then increase the field size then change to column back to hyperlink type. Strange how there is no field size option for hyperlinks.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...