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 transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ------------------------------------------------------------------------- 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
