Want to make a Website Link have the name of another field

[John]

What I am doing is having a list of reports that are
opened up. I have a link to their location on the server.
Instead of have the link name shown on the link I would
like to have the report name instead. I do not want to
have the report name as the label and then the link but
just the reportname with the link as the control source
behind it.

I have created a table to populate this form automatically
when some added another report to the table otherwise I
would just create hyperlink fields.

Thanks in advance,
John

 

[John Nurick]

Hi John,

Behind the scenes, Access stores the data in a hyperlink field like this

DisplayText#Address#SubAddress

where DisplayText is what appears on screen, Address is the URL of the
document or web page or whatever, and SubAddress - not often used - is
the location within the document, e.g. an anchor on a web page or a
bookmark in a Word document.

So you can assemble them just how you like them. Look up (in the VBA
Editor) help on HyperLinkPart for more information.