Hyperlinks not working correctly

[riggsd]

I created some new tables with a hyperlink field and copied the URLs from a different table into the new table.

The original field was not a hyperlink field so, in the new table, the hyperlink doesn't work when it is clicked on unless you cut the URL, paste, then delete the two pound signs (##) that now display at the end of the URL. If you exit the field before deleting the two pound signs, then the link still doesn't work.

Is there a way to "activate" all the links without having to do the "cut, paste, delete" actions for thousands of URLs?

Thanks in advance.

 

[xenou]

Possibly you can recreate them with a vba procedure. Not sure what kind of hyperlinks you have - you may also be able to test them with a "follow" method to check if they work before you "fix" them.

 

[welshgasman]

Try running an update query to replace the hyperlink field with the code below
Take a backup first

Split(hyperlinkfield<hyperlinkfield>,"#",2)

I created some new tables with a hyperlink field and copied the URLs from a different table into the new table.

The original field was not a hyperlink field so, in the new table, the hyperlink doesn't work when it is clicked on unless you cut the URL, paste, then delete the two pound signs (##) that now display at the end of the URL. If you exit the field before deleting the two pound signs, then the link still doesn't work.

Is there a way to "activate" all the links without having to do the "cut, paste, delete" actions for thousands of URLs?

Thanks in advance.

</hyperlinkfield>