Hyperlink Property
You can use the Hyperlink property to return a reference to a Hyperlink object. You can use the Hyperlink property to access the properties and methods of a Hyperlink object associated with a command button, image, or label control. Read-only.
expression.Hyperlink
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The Hyperlink property is available only by using Visual Basic.
Example
The CreateHyperlink procedure in the following example sets the
hyperlink properties for a command button, label, or image control to the
address and subaddress values passed to the procedure. The address setting is an
optional argument, because a hyperlink to an object in the current database uses
only the subaddress setting, To try this example, create a form with two text
box controls (txtAddress
and txtSubAddress
) and a
command button (cmdFollowLink
) and paste the following into the
Declarations section of the form's module:
Private Sub cmdFollowLink_Click()
CreateHyperlink Me!cmdFollowLink, Me!txtSubAddress, _
Me!txtAddress
End Sub
Sub CreateHyperlink(ctlSelected As Control, _
strSubAddress As String, Optional strAddress As String)
Dim hlk As Hyperlink
Select Case ctlSelected.ControlType
Case acLabel, acImage, acCommandButton
Set hlk = ctlSelected.Hyperlink
With hlk
If Not IsMissing(strAddress) Then
.Address = strAddress
Else
.Address = ""
End If
.SubAddress = strSubAddress
.Follow
.Address = ""
.SubAddress = ""
End With
Case Else
MsgBox "The control '" & ctlSelected.Name _
& "' does not support hyperlinks."
End Select
End Sub