[AccessD] Hyperlink in Access

Julie,

Just a thought as I have never worked that much with Hyperlink fields, if
your report looks at a query then couldn't you add something like this to
it:

	SELECT Left([HyperlinkField], (instr([HyperlinkField],"#")-1)) As
RptWebAddress 

Paul Hartland
Database Developer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie
Reardon-Taylor
Sent: 13 September 2005 16:38
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Hyperlink in Access

Hi Jim,

I guess I could do that.  Was just hoping that I could wrap "format()" 
around the field on the report and take out the hyperlink portion.

You see, they have entered the URL into the field which by definition is a
hyperlink, so when you view the field on a form, all you see is the
www.businessname.com.  However, behind the scenes, Access has also added the
#http://www.businessname.com# in addition to the web address.  So you see,
there are two URL's that show up on the report.



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
44 Public Square Suite #5
Watertown, NY 13601
Phone/Fax: (315) 785-0319
www.pro-soft.net


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com