Hi all
I have a database of 475 plant species, each of which [should] have 4 active hyperlinks to pages on other sites.
I imported these links from an Excel file into a table where the link text fields were set as Hyperlinks, then used an Update Query to bring them into the main table - in this, too, the fields were set to be Hyperlinks.
In the table view (and the associated form view) they show up blue and underlined, and the text within is the correct URL; however, they do not work as hyperlinks. If I copy the text into an empty short text field, then re-select and copy back - then they work as hyperlinks, but I really don't want to be doing that 1,900 times.
Is there a way to correct this issue?
Thanks in advance
Edwin