Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1483
  • Last Modified:

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
0
pstanyer
Asked:
pstanyer
1 Solution
 
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
 
Computer101Commented:
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now