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

L

lockdown80

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
 
A

Allen Browne

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
 
Top