Is there a way to change data type (hyperlink) in a Linked Table?

[vha7]

Hi all,

So I went from changing from a normal table (imported data from an excel file that contains links to publication/paper pages; did the hyperlink --> memo --> hyperlink method to get the link to work which it did). However, I changed my table to a linked table where I am able to update the excel spreadsheet on a monthly basis to update my form results, BUT, the data type for my 'Link to paper' field is now defaulted as "Text" and am unable to make any changes to it.



Is there a way to switch it so my hyperlinks work again on my form?

[June7]

Can use code executing FollowHyperlink method.