Hyperlink

[Michelle]

Hello,

What I am trying to do is this:
I have a field called Archive Link on a form which has a
control source linked to Archive Link field defined in
the table. In the archive link field is a concatenation
of some text and another field on the form called Binder
number. The concatenation forms the address of the
hyperlink, which I want to be able to click to open both
in the form and in the table.
Problem:
I used the Application.FollowLink in the On_click event
of the Archive LInk field on the form and that will open
up teh link. However, I noticed that it doesn't actually
set the text in the field as a hyperlink address, as a
result it only transfers to the table as text, although
it is of hyperlink type for the table field. How can I
make it such that the text is stored as the address in
the form field or how can I update the text in the table
field to ensure that they will follow the link
appropriately?

Any help on this would be much appreciated.

Michelle

 

[Allen Browne]

Hi Michelle.

The hyperlink address is made up of 3 parts, with # in between.
Your code needs to assign something (perhaps the same text) to the first two
parts, e.g.
Dim strWot2Show As String
strWot2Show = \\SomeServer\SomeShare\SomeFile
Me.[MyHyperlink] = strWot2Show & "#" & strWot2Show & "#"

For more information, open the Immediate window (Ctrl+G) and enter:
HyperlinkPart
Then press F1.

Alternatively, visit:
Introduction to Hyperlink fields
at:
http://users.bigpond.net.au/abrowne1/casu-09.html