Email Hyperlink in a Report

[Guest_imported]

Can I display just the HyperlinkPart acDisplaytext of a email in a Label report? The report is based on a query.  I need to eliminate the mailto:

 

[DougP]

Not sure what your after exactly but<br>If it is a text item such as &quot;Mail To:<A HREF="mailto:somebody@somewhere.com">somebody@somewhere.com</A>&quot; and you wan to eliminate the first few characters<br><br>Then use the Mid statement, and here is a little function to do that.<br>---------------------------------------------<br>Public Function GetJustEmail(WholeEmail)<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim x As Integer, WholeEmail, Email As String<br>&nbsp;&nbsp;&nbsp;&nbsp;'WholeEmail = &quot;Mail To:<A HREF="mailto:somebody@somewhere.com">somebody@somewhere.com</A>&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;x = Len(&quot;Mail To:&quot&nbsp;&nbsp;'&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Put the mail to exact charaters to eliminte here<br>&nbsp;&nbsp;&nbsp;&nbsp;GetJustEmail = Mid(WholeEmail, x + 1, Len(WholeEmail) - x)<br><br>End Function<br>---------------------------------------------<br><br>Call it like this<br>x = GetJustEmail(&quot;Mail To:<A HREF="mailto:somebody@somewhere.com">somebody@somewhere.com</A>&quot<br>the value of X will be &quot;<A HREF="mailto:somebody@somewhere.com">somebody@somewhere.com</A>&quot;<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

Doug, thank you but it is based on a Email Hyperlink not text. I will explore your suggestion.