Multiple Hyperlinks in a single field

[Guest]

I saw this question in public access and the answer was not clear to me.
Hopefully somebody can break it down a little more for me as I am in need of
the same answer.

I have a project that gets daily reports done in "notepad". I want my form
to show multiple hyperlinks in a single field for that project. I really
need the hperlinks to be shown in one field ecause the form would just get to
big if each of them were shown in their own field. a list box would do no
good as sometimes I have to export this form into excell.
Thanks,

 

[John Nurick]

I can't think of any remotely easy way of doing this.

Assuming that these are just URLs, e.g.

http://support.microsoft.com/?id=132003

you could store them all in a memo field, one per line, and tell the
user to (1) use the mouse to highlight a URL and (2) click a button.

Assuming the textbox displaying the URL is named "txtURLs" and the
button is named "cmdLaunchURL":

1) declare a private module level variable in the form's module, just
after the Option Explicit declaration that you should also have there:

Dim strURL As String

Then put this line into the Exit event procedure of txtURLs:

strURL = Me.ActiveControl.SelText

and this into the button's Click event procedure:

Application.FollowHyperLink strURL