Forum Discussion
Update hyperlink addresses for a recordset using VBA
Greetings VBA Access gurus, I am trying to find the correct code to firstly list the existing target addresses for a recordset of hyperlinks, and then to update the address to a new SharePoint ad...
Rodster, the core problem here is that a Field has no Hyperlink property.
You can use the built-in https://msdn.microsoft.com/en-us/library/office/ff844740.aspx method to extract individual parts of the value of a Hyperlink column. I also published more https://codekabinett.com/rdumps.php?Lang=2&targetDoc=access-hyperlink-data-type.
In general, I rather advise against using the Hyperlink data type because it has some issues without bringing much benefit. Using a simple text column is often a better approach.