Access not recognizing hyperlinks

[equicidal]

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 January 12, 2013 by equicidal

[niche]

Please post your relevant code.

[equicidal]

Please post your relevant code.

post updated with code

[justsomeguy]

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.

[equicidal]

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?

[justsomeguy]

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

[equicidal]

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.