update hyperlink addresses on mass

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

Guest

Hi

I have table with a hyperlink field in it. Is there a way of updating the
address of the hyperlinks on mass.

Thanks
Matt
 
Hi,
sure...you can run an update query on the values like you can for any other
data type.
A hyperlink can consist of three parts which are seperated by pound '#'
symbols. The first part is the display text, the second the link itself, and
the third could be a reference within the link destination.
So if you wanted to replace ALL hyperlinks with the same one then for
example you could use this in the update to area of your update query:

Left([HyperLinkField],Instr([HyperLinkField],"#")+1) & http://www.msn.com

If you run the update query you would replace ALL links with msn.com. They
display text would stay the same.
HTH
Good luck
 
Back
Top