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

[Guest]

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?

 

[Jason Rice]

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