The # character in a hyperlink is used to separate hyperlink parts. Here is a case when I do NOT want this character to do the separation: a network file where the # character is part of the filename: k:\data\someFile#ref02.doc.

How can I put this URL into a hyperlink field in a table and NOT have Access treat it like this:
Address: k:\data\someFile
Subaddress: ref02.doc
which then of course results in the usual "Unable to open..." error.

(I tried replacing the # with %023 but when Access seems to convert it automatically to #).

Try in inverted commas - "k:\data\someFile#ref02.doc"

Chris B

I copied your "k:\data\someFile#ref02.doc" into the Address box of the Edit Hyperlink window and it gave me the following error:
Unable to open %22k:\data\someFile
i.e. its still chopping off the all after #, thinking its a subaddress.
Any other idea?
Thanks

The Hash character has a special meaning in html and can't be used to reference a file.

Any reference will truncate after the hash.

Simon