Hi,
Access uses the # sign to separate the three parts of a hyperlink field:
the display text, the actual address, and the subaddress (e.g. an anchor
on an html page or a bookmark in a Word file). The use of # between
address and subaddress is standard for URLs, not just a trick of
Access's.
So it's not that hyperlinks can't contain #, rather that the names and
paths of files you want to hyperlink to can't contain it. So you'll
either have to rename your files (one more reason to avoid special
characters in filenames) or stop using the Hyperlink field type
(instead, store the filespec as text and use the Shell() command to
launch it).
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.
