Robin-
You should never see the formatting for a properly defined Hyperlink field.
If you want the Hyperlink to be active in Report View, make sure the Is
Hyperlink property says "Yes". In Print Preview, the Hyperlink should
appear as normal text.
Is this happening because you're actually pulling the data into a .asp web
page? If so, you'll have to create an expression in your query to format it
as an HTML hyperlink.
HTMLeMail: "<a href=""mailto:" & Left([EmailAddress], Instr([EmailAddress],
"#") - 1) & ">""" & Left([EmailAddress], Instr([EmailAddress], "#") & "</a>"
The above code assumes the email address is always replicated in the
"display" portion of the hyperlink data, as in:
robinski@mymail.net.au#mailto:robinski@mymail.net.au#
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Monday, May 06, 2013 12:36 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access report with email address
I am planning an Access report which includes members' email addresses,
The email address is in the database as an hyperlink, In the report it is
also formatted hyperlink.
When I take the report the email address is followed "#mailto:" and the
address again.
What is the correct technique to have an active hyperlink in the report?
Many thanks,
Robin
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar