I don't know if this works in A97:
For intance your hyperlink field name is txtHyperlink
private cmdOpenHyperlink_click
me.cmdOpenHyperlink.hyperlinkAddress = me.txtHyperlink
end sub
hth
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of Gary E. Daniels
Sent: Sunday, October 08, 2006 9:24 PM
To: [email protected]
Subject: [ms_access] Hyperlink Button
Hi. I'm running Access 97. I'd like to know how to have a Command Button
as a hyperlink. Each record in my database has a unique hyperlink field
displaying the entire URL. This works fine, however, it does make the form
appearance look cluttered. I'd rather not display the URL field, but
instead have a Command Button that OnClick would take the user to the
website of the URL for an individual record.
Any suggestions?
Thanks in advance.
Gary
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/