Updating hyperlinks

[etk]

I would like to be able to update a hyperlink such that I can specify text to display and the address, but whenever I update it only changes the text to display.

Basically I have a table that is just an ID nubmer (Doc_ID) and the hyperlink and I want to update the Hyperlink so that

Text to Display: "Document #" & Doc_ID
Address: "//filestring/Document_" & Doc_ID & ".docx"

Can I do this with the query, or do I need VBA?

 

[burrina]

You are wanting to display this where? Generally you edit a Hyperlink by right clicking it and editing.

 

[etk]

You are wanting to display this where? Generally you edit a Hyperlink by right clicking it and editing.

Eventually, the idea is to put this into a SharePoint List. I figured it might be easier to fix it on the database side first before making that transition. Looking for the most efficient solution to the problem. Right clicking and editing hundreds of hyperlinks is not an option.

 

[burrina]

You did not say you needed to edit many Hyperlinks.

Good Luck With Your Project!