[AccessD] RE: Hyperlink Field

JMoss jmoss111 at bellsouth.net
Thu Mar 18 10:19:44 CST 2004


I set a column to type text, and the text box on the form to ishyperlink and
the hyperlink worked perfectly. Then I set a column to type hyperlink and
left the text box as is and the URL worked perfectly too.  Only after I
changed data type did I ever see the #. I had to delete the column from the
table and recreate to get rid of the last behaviour, ie the #

Using Win 2000/Access 2000 for this case.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz
Sent: Wednesday, March 17, 2004 2:46 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] RE: Hyperlink Field


Using Access 2000, I use Hyperlink datatype in the table and just a regular
textbox in a form.  No need to set the IsHyperlink property.  Cursor is a
hand when the mouse goes over the textbox and it launches a browser instance
pointed at the URL when clicked once.  Text appears as plain text in the
textbox.  If I store:

ezonemag.com

in the table, it appears as a hyperlink in the table but looks like plain
text in the textbox.  Tab into the field and hit F2 (edit) and it changes
from hyperlink to clickable text until the focus is off the text box again
when it reverts to acting like a hyperlink but looking like text.  Text
shown in the text box for the example is:

ezonemag.com#http://www.ezonemag.com#

I've never tried setting the IsHyperlink property True before today and the
difference on my system (still running Win 95 on my current work machine, 64
meg peer 'server') is that it displays as a hyperlink in the textbox.
Hitting the edit shows the same text, but underlined like a hyperlink, as
though the IsHyperlink property was false.

Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com

_________________________________________________________________
MSN Premium with Virus Guard and Firewall* from McAfee® Security : 2 months
FREE*
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt
p://hotmail.com/enca&HL=Market_MSNIS_Taglines

--
_______________________________________________
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