How do I create a hyperlink using two fields

How do I create a hyperlink using two fields - 1 txt display 2 URL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LMcLeod - 28 Apr 2005 13:32 GMT

I'd like to create a hyperlink using one field/column for the text display
and another field/column for the URL. This can be done in Excel using the
following formula:
=HYPERLINK(link_location,friendly_name).

I think I might be able to use a text box bound to a field that contains
hyperlinks, but haven't found an easy to follow/idiots guide for this.

Can anyone help?

Reply to this Message

Jason Rice - 28 Apr 2005 19:50 GMT

There are a few methods that you could use to do this.

If you have a list of URLs that you want to display and plan on keeping them
in a table, then you can se a field data type to "Hyperlink" in the design
of the table. Then just set a text box control source to that field on a
form.

Alternatively, you can dynamically change the text/URL for the hyperlink
using the properties of the field on the form (you can use a label for
this):
Label.Caption="Some Value" 'sets the text
Label.Hyperlinkaddress="Some Value" 'sets the URL address

HTH

Signature

Jason Rice

> I'd like to create a hyperlink using one field/column for the text display
> and another field/column for the URL. This can be done in Excel using the
[quoted text clipped - 5 lines]
>
> Can anyone help?

Reply to this Message