Since SQL Server doesn't have a hyperlink-type field, this will need to be solved in the app itself. In other words, you will need to handle some of the events into that textbox (use the onClick event and manage what you want to do inside that sub), or redesign the form layout a bit to provide a place to click on the URL and the textbox for editing.
David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: [EMAIL PROTECTED] Hi Gang, Sorry to be OT this morning, but perhaps someone has dealt with a problem we are having. We took an Access application and hooked the backend to linked tables from a SQL Server database, maintaining all the forms, etc. from the Access app. On one of our form pages there is a field for a hyperlink. Access has a datatype "hyperlink" and all we had to do was type in the URL and it worked. If we wanted to edit the URL we right-click and edit. Unfortunately, the same control (text box) pulling data from the SQL Server tables just displays it as text. It is colored blue and underlined so it looks like a link, but when you click on it the cursor goes into the field for editing instead of behaving like a hyperlink. Has anyone ever handled this before - perhaps with VBA? If so can you suggest some code that might work? Thanks, Loyd Campbell Bank One Corp. ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
