Solved

Hyperlinks show # (hash) symbol in reports

Posted on 2007-11-19
4
1,465 Views
Last Modified: 2013-11-28
I have a very simple database created in Access 2003, and since ported to 2007. In once table I have several columns containing hyperlinks. When I add those fields to a report, the hyperlinks show "#" hash symbols at the begining and end of each hyperlink on the report.

I have managed to stop the report underlining each hyperlink, which is great, but where are these # symbols coming from, and how do I remove them?

Many thanks in advance
0
Comment
Question by:pstanyer
4 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 20313986
you can use the replace function
replace([Url],"#","")

or take a look at  HyperlinkPart function

SELECT URL, HyperlinkPart([URL],0)
    AS Display, HyperlinkPart([URL],1)
    AS Name, HyperlinkPart([URL],2)
    AS Addr, HyperlinkPart([URL],3)
    AS SubAddr, HyperlinkPart([URL],4)
    AS ScreenTip
    FROM Tablename
0
 

Author Comment

by:pstanyer
ID: 20314012
I think... I have found the solution after more fiddling.

In the properties section of the field in the report, I select the option under Format Properties, Is Hyperlink - yes. The #'s disappear.

Thanks though!
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 21186181
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now