filtrationproducts
asked on
Issue with Hyperlink 'Text to Display' containing # Symbol in Access
I have a Access front end that displays a hyperlink retreived from a SQL server. The problem is that one of the 'text to display' part numbers has a # symbol in it and that causes it truncate or not connect to the proper hyperlink in the back ground. Is there a way to encapsulate this # symbol so it wont affect the hyperlink?
Or wrap in single quotes
YourHyperlinkField=Replace (YourHyper linkField, "#","'#'")
YourHyperlinkField=Replace
filtrationproducts,
I don't tihink there is anyway to include the # in any part of a hyperlink.
boag2000 is right about needing to replace the # but you only want to replace the first instance so:
YourHyperlinkField=Replace (YourHyper linkField, "#","",1)
Note: this will only work with situations where there is a hash (#) in the display text.
You may want to count the number of #'s first to determine if there are more than 3 etc.
I don't tihink there is anyway to include the # in any part of a hyperlink.
boag2000 is right about needing to replace the # but you only want to replace the first instance so:
YourHyperlinkField=Replace
Note: this will only work with situations where there is a hash (#) in the display text.
You may want to count the number of #'s first to determine if there are more than 3 etc.
ASKER
The hyperlink is created from a query. Here is what the problem hyperlink data looks like.
TORO # 74-3570#J:\elements\docume ntation\TO RO # 74-3570.SLDDRW#
TORO # 74-3570#J:\elements\docume
ASKER
I tried putting the code below in the query for the "display text" field. But its not working.
Replace("#","")
How can I configure the 1 column in the query to remove the # symbols.
temp.JPG
Replace("#","")
How can I configure the 1 column in the query to remove the # symbols.
temp.JPG
ASKER
I changed ID to display only the word "drawing" but the # symbol in the hyperlink itself causes it to error. I dont know if this is going to be possible.
Is there anyway to make a hyperlink containing a # symbol work in Access. I cant remove the # because its the actual filename and this cannot be changed.
Is there anyway to make a hyperlink containing a # symbol work in Access. I cant remove the # because its the actual filename and this cannot be changed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tramtrak: I will try that now
Well, without seeing the string, all I can suggest is that you replace the "#" with an empty string (""):
YourHyperlinkField=Replace
Can you paste the string here for us to examine?
JeffCoachman