How Can I Convert a Field of a Linked Table Back to Hyperlink

[RunTime91]

The web seems to dance all over this issue without providing a solution...

Here is my issue ~

I am converting my local Access table to SQL 2014 - I know once I do I will lose the Hyperlinks as SQL will (or I will) convert them to VarChar.

My dillemma is how to restore the now text value back to an active hyperlink value.

The local table with the active hyperlink field is the data source for a listbox which is bound to the hyperlink field



This allows the users to find the record they are looking for in the listbox then simply click on the record to access more information from the web.

My current effort involves populating the ListBox with a Query of the Linked Table and within the query try to re-format the Hyperlink field (which is now SQL text) back into active Hyperlinks

Which, if this can be done should allow the end users to once again click on a record in the ListBox to open a web page

Here is how SQL is storing the hyperlinks

http://kb.ancd.ancdelp.com/ancdkb_00002546.htm#http://kb.ancd.ancdelp.com/ancdkb_00002546.htm#
Here is the current SQL Statement I am trying to get to work - As you will see I'm trying to just Format it back to a hyperlink - Yep - Not working

SELECT dbo_MyTable.RecID, dbo_MyTable.Description, dbo_MyTable.[B-Refs], dbo_MyTable.[L-Codes],
Format(HyperLink(dbo_MyTable.HyperLinkField AS Instructions, dbo_MyTable.Group, dbo_MyTable.Notes
FROM dbo_MyTable;

Fwiw - I have tried HyperLinkPart as well - Fail!

Thanks so much for any help

RT

[pbaldy]

Presuming the field simply contains the plain text:

http://kb.ancd.ancdelp.com/ancdkb_00002546.htm

I wouldn't try to convert it to a hyperlink, I'd put code behind the click or double click event to open the link with FollowHyperlink.

Eidt: Forum turned the plain text into a hyperlink

[RunTime91]

OMG!!

Geez!! Paul, you got me jsmh...

I thought because it no longer 'looked' like a hyperlink - then hell it must not be a hyperlink...

Ok, you can stop laughing now..

Thanks Paul ~!

[pbaldy]

Happy to help! I'm not laughing, done similar things too many times myself.