Solved

Hyperlinks show # (hash) symbol in reports

Posted on 2007-11-19
4
1,469 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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