Hyperlink not working in Access 2010

I FIGURED IT OUT!!!!!!!!!

Unlike Word and Excel, in Access each entry has to be primed:

1. In Forms design mode, make sure the field is set to hyperlink (Is Hyperlink = Yes).
2. In Forms or Table view, right mouse click on the field and select Hyperlink then Edit Hyperlink
3. When the Insert Hyperlink window is displayed, Paste the url into the Address field.

You only have to do this once for each entry in the form.  Once all urls have been primed the hyperlinks work perfectly.

How is the hyperlink being populated?  Are you inputting it on the form itself or perhaps programmatically or maybe you converted a text type field to a hyperlink type field in the table?

I would suspect the values may be missing the surrounding character(#) it should have in order to work how you expect.  As an example the value www.microsoft.com should really be #www.microsoft.com# in your table.

The hyperlink data type is more trouble than it's worth.  It's simpler to store the value in a simple text column, and format the bound control to look and behave like a hyperlink, using code in its Click event procedure for follow the link.  Users should only interact with data via a form of course, never in a table's datasheet.

You'll find an example in BrowseDemo.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.

This little demo file is really intended to illustrate how to return the path to a file and then open the file from the form, but as regards its 'hyperlink' functionality it will work equally well with a Web URL.  You can try it yourself by pasting a URL into the full path control in the form.  My code calls the Windows API ShellExecute function, but to simply follow a link you could just call the FollowHyperlink method of the Application object.

BTW a relational database table does not have cells, it has values at column positions in rows.  Cells are a spreadsheet concept.  Do not be misled by the superficial similarity between a datasheet and an Excel worksheet.  A relational database is very, very different from a spreadsheet in concept and methodology.

I FIGURED IT OUT!!!!!!!!!

Unlike Word and Excel, in Access each entry has to be primed:

1. In Forms design mode, make sure the field is set to hyperlink (Is Hyperlink = Yes).
2. In Forms or Table view, right mouse click on the field and select Hyperlink then Edit Hyperlink
3. When the Insert Hyperlink window is displayed, Paste the url into the Address field.

You only have to do this once for each entry in the form.  Once all urls have been primed the hyperlinks work perfectly.

Same here. Amazing. After all these years it may not be surprising anymore, but I still am astonished that the coders at MS didn't think to automatically copy the cell value, which is a FULLY FORMED URL, into a CURRENTLY UNSET address setting for a field object. We have to "prime" each record manually. Really. WTF

But thanks for posting the workaround Melvannie :) 

This is the very first time I've ever spouted off about MS online BTW. Just a boiling point I guess. Sorry.

Hi

 I know this may be obvious but make sure you have selected the correct Link in or Look in box so the hyperlink knows where to look. Type correct address in address box.