Jump to content
Sign in to follow this  
equicidal

Access not recognizing hyperlinks

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

Share this post


Link to post
Share on other sites

Please post your relevant code.

Share this post


Link to post
Share on other sites

It sounds like a problem with Access if it isn't recognizing URLs and letting you click them. Make sure the URLs are properly formed, otherwise it sounds like a problem with Access.

Share this post


Link to post
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?

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...