Hyperlinks -- can I change the "Text to Display"?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that includes several lengthy hyperlink addresses and I would
prefer the recipient of the report only see "Click here to Register" instead
of the complete address.

Is this possible?
 
I can't help but I sure would like to know how to do it.
I know if you have the adress set up as so:
displaytext#address you can use hyperlink part() to display the displaytext,
however if you are like me and only have the addres I am not sure.
 
John....thanks to your comments I was able to figure it out. Turns out if
you right click on the link (not the entire cell) within your
table/query/form...you can edit the hyperlink and then change the "text to
display." This is then the data that appears on the report.

Hope this helps you too!
 
Thanks Kim,

Unfortunatly for me, my hyperlinks feed from another file via a link so it
doesnt let me change the display text in access itself.
My work around was to add the display text to the bigining of the hyperlink
in the source file ie. added displaytext#www.hyperlinkaddress.

By default access diplays the displaytext so i am happy.

Although One day I would like to use another field as the displaytext for a
hyperlink in another field. This I am not to sure on. Might have to create a
new field in a query that adds the two fields together with the # inbetween.

Cheers,
 
Back
Top