That's because they aren't really hyperlinks, just text strings. If you want a true hyperlink then must use Hyperlink type field and the hyperlink dialog box to populate field. Otherwise, need code to take the text string and act on it as a hyperlink. That's what the intrinsic FollowHyperlink method is for. I just tried using FollowHyperlink in a new db to open PDF files. Crashes my system. Very odd because it used to work with Windows XP and Access 2007 on 32-bit PC. So I switched to Shell method.
Code:
Private Sub tbxLinkToFile_Click()
On Error GoTo ErrProc
'FollowHyperlink is not working properly
''Application.FollowHyperlink Me.tbxLinkToFile
If Dir(Me.tbxLinkToFile, vbArchive) = "" Then
MsgBox "File path not found."
Else
Dim wsShell As Object
Set wsShell = CreateObject("WScript.Shell")
wsShell.Run Chr(34) & Me.tbxLinkToFile & Chr(34)
End If
ExitProc:
Exit Sub
ErrProc:
MsgBox "Cannot open document. Contact database administrator. : " & Err.Number
End Sub
Review:
http://www.allenbrowne.com/casu-09.html
http://allenbrowne.com/func-GoHyperlink.html
Unfortunately, the Allen Browne GoHyperlink function still uses FollowHyperlink method.