[AccessD] Hyperlink in Access

Jim Lawrence accessd at shaw.ca
Tue Sep 13 10:20:21 CDT 2005


Hi Julie:

Would it not be easy to pre-process the field contents removing the '#' from
both ends and print the result?

Mid(txtMyField1.txt,2,len(txtMyField1.txt)-1)

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie
Reardon-Taylor
Sent: Tuesday, September 13, 2005 8:00 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Hyperlink in Access

Hi List,

I have a different kind of question.  I'm using an Address Block for a 
snaking report.  Within the "members" table, I have a field for Website 
Address formatted as a hyperlink.  When the field shows up on the report, it

looks like this:  www.businessname.com #http://www.businessname.com#

This is obviously because of the hyperlink.  Is there a way to format that 
field so that the http portion does not show up, yet still maintain the 
hyperlink in the table?

The users like the hyperlink, because all they have to do is click on the 
web address and the hyperlink takes the user right to the members website, 
so I would hate to get rid of it.

Any ideas?





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




More information about the AccessD mailing list