Hyperlinks from queries

Hi all
What I'm trying to do is farily simple, but I've having loads of
trouble achieving it.
Basically I have a report generated based on a query which then gets
outputed as a PDF.
I would like to create a hyperlink where the "text to display" is taken
from one field (name:textname) and the hyperlink address is from
another field (name:link)

At the moment I'm having problems as both are obviously unbound, so
they can't be made into hyperlinks.

I've written this code;
--------------------
Function Links()

Dim link As String
Dim name As String

link = Me.link
name = Me.name

Me.label.hyperlink.address = link
-----------------------

with a label called Label

but I generate the report and output as pdf, the link doesn't work.
Also, how do I change the text to display so it matches the output of
the name field?
Help. This is driving me nuts as there is next to no documentation on
this.

Thanks in advance
T.

I have been researching a solution to the same problem. If anyone is able to
provide a solution or has provided a solution, please post it here. Thanks!

" wrote:

Hi all
What I'm trying to do is farily simple, but I've having loads of
trouble achieving it.
Basically I have a report generated based on a query which then gets
outputed as a PDF.
I would like to create a hyperlink where the "text to display" is taken
from one field (name:textname) and the hyperlink address is from
another field (name:link)

At the moment I'm having problems as both are obviously unbound, so
they can't be made into hyperlinks.

I've written this code;
--------------------
Function Links()

Dim link As String
Dim name As String

link = Me.link
name = Me.name

Me.label.hyperlink.address = link
-----------------------

with a label called Label

but I generate the report and output as pdf, the link doesn't work.
Also, how do I change the text to display so it matches the output of
the name field?
Help. This is driving me nuts as there is next to no documentation on
this.

Thanks in advance
T.