How to edit hyperlink in runtime (Access 2007)?

How do I edit a hyperlink in runtime when I have no right mouse click?

Hyperlink is a field that links PDFs located in the same folder as the app.
notpandoraAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
I try to avoid using these "Access Only" Fields (Hyperlink, OLE, attachment, ...etc)
They will not translate into other formats like SQL server, and they have issues like the on you are having.

Here is a very simple example of what I use to do this.

I am sure you can adapt it to work in your database

;-)

JeffCoachman
Access-EEQ-26464463-LinkedPDFDia.mdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
Edit it how?

You can edit any hyperlink by editing it directly in the table.
In a form, you can Tab into the Hyperlink field and change it.

Or you can do this in a form via code with something like this:

    me.YourHyperlinkControl.SetFocus

;-)

JeffCoachman
0
 
notpandoraAuthor Commented:
In full Access I just right mouse click on the form field and click Hyperlink / Edit Hyperlink and I can browse for the file and link it. In runtime I have no right click so can't access this menu....
0
 
notpandoraAuthor Commented:
Thanks Jeff, got it working in the end. Thanks again...fc
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.