G
Guest
I have inherited an old table of data where hyperlinks that were entered have
somehow had the string value for the address removed or changed so that the
hyperlinks are not working. However, the values of the texttodisplay/Display
Text is correct. Is there a piece of code or a query that I could use to
update the address text to match the display text of the hyperlink?
Any help would be greatly appreciated!
Have been trying for ages to solve it with some VB code by looping through
the recordset of all records with hyperlinks but when I try to retrieve the
hyperlink field's value from the recordset i.e. recordset("Hyperlink"), a
string is returned rather than a Hyperlink object which means I can't
maniuplate the various properties of the hyperlink object in VB
somehow had the string value for the address removed or changed so that the
hyperlinks are not working. However, the values of the texttodisplay/Display
Text is correct. Is there a piece of code or a query that I could use to
update the address text to match the display text of the hyperlink?
Any help would be greatly appreciated!
Have been trying for ages to solve it with some VB code by looping through
the recordset of all records with hyperlinks but when I try to retrieve the
hyperlink field's value from the recordset i.e. recordset("Hyperlink"), a
string is returned rather than a Hyperlink object which means I can't
maniuplate the various properties of the hyperlink object in VB