How do I set up a hyperlink in a form that's a text field in a tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a text field in my database and I want to show it twice in my
form. Once as a text field that can easily be edited and again as a
clickable hyperlink. Nothing I've tried seems to do both. I am not a coder
and would appriciate any help anyone could offer. Also, if anyone bas a
better way of doing what I'm trying to do please let me know.

Keith
 
You could use the Click event of the text box to run the FollowHyperlink
method.

Example, if the text box contains http://allenbrowne.com, then:

Private Sub Text1_Click()
If Not IsNull(Me.Text1) Then
Application.FollowHyperlink Me.Text1
End If
End Sub
 
Back
Top