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