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.
 
Back
Top