Display Text Field but Use Hyperlink Field in report (1 Viewer)

[brushbrooke]

I have a table with various items of info on plants. One of the fields, a Text Field is it's name [Taxon] another field, a Hyperlink Field is the URL of an image of that plant uploaded to Flickr [flickr URL].
In a report that will be published as a PDF I would like to display the [Taxon] field but have it appear as a hyperlink that works off the [flickr URL] field.
e.g.
For
[Taxon]: Lilium 'Garden Party'
[flickr URL]: httpxxxxxxx/6143164095/ can't type this field in propperly as I don't have the prerequisite 10 post to this forum, anyway it's a URL of a page on flickr.
I would like to show:
Lilium 'Garden Party' - (with a working hyperlink )

Is this doable & if so how?
Failing that could I maybe use a clickable proxy image, e.g. a wee gif/png icon of a camera auto hyperlinked to the contents of [flickr URL]?

At present I just have the hyperlink field as text after the text field in the pdf report which works but does't look too brilliant.

Been fumbling around in Access for years but have never got around to learning any of the less basic points, so I ask the help of those more able than I.
Ben

 

[vbaInet]

See attached how it can be done in two ways. In the report take note of the properties of txtWebsite and txtAlias.

Open up the form and edit the code behind the command buttons to include the correct file paths. Test it and see how it works.

 

[brushbrooke]

Cheers vbaInet,

I've got a tweeked version of the 1st method working now.
It would never have occured to me to hide the hyperlink field with sneeky white text behind a transparent text field, Ta.

Not all of the records have an image associated so to allow for these I've made a stack of 3 text boxes:
Control Source Bottom to top:
=[flickr URL] Formated with white text & a transparent background

=IIf([flickr URL],[Taxon],"") Displays when there is an URL in the [flickr URL] field, set format of text to look like a hyperlink with the "Is Hyperlink" set to yes & "Display As Hyperlink" set to Always & a transparent background

=IIf(IsNull([flickr URL]),[Taxon],"") On the top a normally formated transparent text box to display the plant name when there is no URL in the [flickr URL] field.

Seems to be working nicely,
Ta Again.

 

[vbaInet]

You're welcome

In that case, no need for the extra textbox. You could just use Conditional Formatting and turn off the Is Hyperlink property. See attached.

NB: Remember to set the Allow Zero Length property of the URL field in the table to No.

 

[brushbrooke]

Much more simple & elegant, cheers again vbaInet.

 

[vbaInet]

No problemo!

 

[Gasman]

@vbaInet
Would just like to say Thank You for this tip.
You helped with this particular DB I wanted to do this for today, when I first created it, and 9 years on, are still assisting.