Opening hyperlinks in a multiple records form

[an1bone]

Hello,



I have a field in my table with hyperlinks that are specific to each record. In my form, I want to be able to open the hyperlinks when on each specific record. I know how to do this using a textbox control, but I don't like how the entire file location is displayed in the text box on the form. Is there a way to hide this file location and instead display the words "Click to open this hyperlink" in the textbox? If this isn't able to be done, is it possible to create a Command Button that opens the hyperlink for each specific record (I know the command button is usually a fixed control that doesn't change for each record). Are there any other solutions to this issue? I simply want to be able to open the hyperlinks without having the file locations visible. Also, I would prefer not to have to use VB!

Thank you!!

[June7]

Unless you store the file path in a Hyperlink type field, I don't think can avoid VBA.

Example from my db:

Private Sub btnLink_Click()
On Error GoTo ErrProc
'FollowHyperlink is not working properly
''Application.FollowHyperlink strPath
Dim wsShell As Object
Set wsShell = CreateObject("WScript.Shell")
wsShell.Run Chr(34) & Me.tbxLink & Chr(34)
Me.Title.SetFocus
ExitProc:
Set wsShell = Nothing
Exit Sub
ErrProc:
MsgBox "Cannot open document. Contact database administrator. : " & Err.Number
End Sub

[an1bone]

@june7 :

Can you specify where this code is used? Is this for a textbox or a Command Button? I'm still very new to VBA and am getting lost in your code. Thank you!

[CJ_London]

if it is a hyperlink control, enter whatever you want the user to see in the caption property (found on the properties other tab)

ignore my suggestion - not appropriate for continuous forms/datasheet

[June7]

It is code from button:

Private Sub btnLink_Click()

tbxLink referenced in code is a hidden textbox with expression that constructs the file path.
="C:\CRM\Library\Materials Reports\Catalogued\" & [DocID] & ".pdf"