Access 2003 Hyperlinks in Forms

I'm calculating a hyperlink that gets written to a file being imported into my access table.
The field is of type Hyperlink

I then created text object on the form that points to the hyperlink field.

Clicking on the hyperlink in the form gives me the wonderful satisfaction of having clicked on it, but it doesn't launch IE :)

Can someone give me some additional steps? I'd imagine that the object is not the correct type?
OnsiteSupportAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
Try the Followhyperlink method in the click event.

Personally I don't like "hyperlink fields", preferring to store the hyperlink as text and use the Followhyperlink method.
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
I'm with fyed.

As cool as a "hyperlink Field" sounds, most of what they do can be replicated with a simple text field.

In any event:
<I then created text object on the form that points to the hyperlink field.>
No really clear on what this means, or why it was needed, ...?

But if you create the form using the form wizard, you can select the table that contains the HL field, and the hyperlink field will come into the form automatically, and should work fine when clicked.

So again, I am not sure what you did there with your "Text Field"...?


JeffCoachman
0
 
OnsiteSupportAuthor Commented:
Thanks guys.  Follow Hyperlink works.  However, not with Text Field.  It works as expected if the field type is Hyperlink.
0
 
Dale FyeCommented:
Can you describe what you were doing that it didn't work with a text field?

I usually do one of two things.
1.  add a button to the right of the text box and use the click event do to something like:

Private Sub cmd_Hyper_Click

    application.FollowHyperlink me.txt_URL

End Sub

2.  Use the double-click event of the textbox with similar code.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
<<Thanks guys.  Follow Hyperlink works.  However, not with Text Field. >>

I only use text files. I never use the hyperlink data type.

I created an example that may help: Document Links 2
0
All Courses

From novice to tech pro — start learning today.