Hyperlinks can't contain pound sign?

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.

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).

On Mon, 17 May 2004 09:46:01 -0700, "Shifted Insights"
wrote:

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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.