Hyperlinks show # (hash) symbol in reports

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
pstanyerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (250)

Computer101
EE Admin
0
 
Rey Obrero (Capricorn1)Commented:
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
 
pstanyerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.