If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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.
|
#2
|
|||
|
|||
Hyperlinks can't contain pound sign?
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. |
Thread Tools | |
Display Modes | |
|
|