Convert string back to hyperlink in Access query from SQL table

[funwithaccess]

I am in the process of building a new database in SQL to replace my MS Access database. However, I will continue to use the Access forms, queries, and reports. The new tables will house much of the same data. In multiple tables I have hyperlinks that were created and added in the original Access tables. To import these hyperlinks into the new SQL tables I have converted them to 'Long Text' before exporting, thus changing them into strings.

For example:
Hyperlink - Email - Add Additional Mailbox to Outlook (2010) has been changed to:
Email - Add Additional Mailbox to Outlook (2010)#\\Servername\Serverfolder\Documentation\Ready to Go\Outlook Templates\Email - Add Additional Mailbox to Outlook (2010).oft#

The obvious issue that I am running into is that after the SQL database table has been linked to the Access database it still displays the entire string when I open the table. The form has a textbox and search button that is used as a search function. This runs a query that returns all "search results" for the desired information. Is there a way that the query can convert the string back into a hyperlink so that the query displays just Email - Add Additional Mailbox to Outlook (2010) as a hyperlink and not the entire string? Or is there another solution?

Thank you in advance!!

 

[funwithaccess]

Update: I found a work around, instead of the information displaying in a query, it will be displayed in a subreport/subform that can convert the strings back into hyperlinks after selecting Is hyperlink: Yes in the properties. Now I am running into the same issue with dropdown boxes. If I do the same thing and select Is hyperlink: Yes in the properties, it displays as a hyperlink but won't open when clicked. Any suggestions?