<div>
you can use the replace function<br />
replace([Url],&quot;#&quot;,&quot;&quot;) <br />
<br />
or take a look at &nbsp;HyperlinkPart function<br />
<br />
SELECT URL, HyperlinkPart([URL],0)<br />
&nbsp; &nbsp; AS Display, HyperlinkPart([URL],1)<br />
&nbsp; &nbsp; AS Name, HyperlinkPart([URL],2)<br />
&nbsp; &nbsp; AS Addr, HyperlinkPart([URL],3)<br />
&nbsp; &nbsp; AS SubAddr, HyperlinkPart([URL],4)<br />
&nbsp; &nbsp; AS ScreenTip<br />
&nbsp; &nbsp; FROM Tablename<br />

</div>


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


<div>
I think... I have found the solution after more fiddling.<br />
<br />
In the properties section of the field in the report, I select the option under Format Properties, Is Hyperlink - yes. The #'s disappear.<br />
<br />
Thanks though!
</div>


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!

<div>
<div class="content wysiwyg-content">
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 &quot;#&quot; hash symbols at the begining and end of each hyperlink on the report. <br />
<br />
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?<br />
<br />
Many thanks in advance
</div>
</div>


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

Hyperlinks show # (hash) symbol in reports

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.