Include address details into Hyperlink field

Hi all,

This following code transcribes a hyperlink string into an Access field from a prepopulated array:

Dim db As DAO.Database
Dim rsImport As Recordset
Dim i As Long, j As Long

Please Login or Register  to view this content.

However, this only imports the string. It's doesn't also update the address details, which means that the hyperlink doesn't work.

So, how do I also include the underlying address details?

Cheers

Seems I didn't get much of a response from the community on this one. However, in the event that somebody else has the same issue, I found the answer.

When importing hyperlinks as text into Access you should wrap it between two hash (#) marks.

e.g.

Please Login or Register  to view this content.

This solution resolved the issue and the hyperlinks now work as intended.

Cheers