Updating a Hyperlink in a Table

  • Thread starter Thread starter Glenn Suggs
  • Start date Start date
G

Glenn Suggs

I have an Access table that has a field defined as a Hyperlink that points to
a file on the server. But when I run an update query to update the field
with the path to the file, the Hyperlink does not work. When I right click
the field (after running the update) and select Hyperlink, and then Edit
Hyperlink, the Text to be Displayed is filled in with the path but not the
Address field itself. It only works when I manually type in the Address as i
can't get the query to update it. Is there some VBA code I can use through
DAO to update the Address part of the Hyperlink as well.
Thanks in advance.
 
Thanks Alex,
That did work but I had to but a # sign at the end of the second part, too.
 
Back
Top