S
Shifted Insights
I am creating a table with a field defined as a hyperlink. The files that these records will link to contain the pound sign (#) in the name. When I construct the hyperlink, Access truncates the link at the pound sign, and thus, Access cannot find the correct link to the file. I have tried editing the link after creating it, to try and add the rest of the file name, but still, Access truncates the hyperlink at the pound sign. Short of trimming out the pound sign of each file name on the server, is there any way around this? There are currently 5000 files I would need to rename, growing daily. Thanks in advance.