Hyperlink Display Text

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

Guest

I'd like to a report to automatically change the display text in a hyperlink field to the text from another field without changing the underlying hyperlink. Is this possible?
 
Gerry:

Sure, hyperlinks are stored in the following format internal to the field:

#http://www.cnn.com# 'no separate display text

CNN#http://www.cnn.com# 'with separate display text

So you could easily loop through your table as a recordset and append to the
front of the hyperlink field data the display text you want to use as a
substitute for the link.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlink in Access Query how to? 2
linking to documents from reports 3
Hyperlinks from queries 1
Hyperlink to Page number in Report that is exported to PDF 5
Hyperlink URL appears messed up in Report Preview 2
Hyperlink created in Access does not function when printed to pdf 2
Kiosk Mode Navigation 0

Back
Top