I recently converted a large spreadsheet to an access table to allow multi-user entry/access to the data and am having troubles with one column that was a hyperlink in excel.
The column is named "location" and has the full path to the file I am trying to hyperlink to eg.
M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-014 01_R0.PDF
M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-015 01_R0.PDF
M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-016 01_R0.PDF
M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-017 01_R0.PDF
I set the data type of the column "location" to hyperlink and all the data turned blue/underlined like a hyperlink but the address of each hyperlink is blank. I am having to go set the hyperlink address manually for each file by copying the "text to display" to the "address" field
Is there some code out there I can run to set the address of these links to match the "text to display"
Thanks
J