create hyperlink from text field

Posted on 2004-11-24
Last Modified: 2006-11-17
On a form I have a text field called SupplierURL, and I need the value of this field to be passed to a label that is clickable. Right now I have a label created called LabelQMSuppURL and in it's properties under Hyperlink Address I have the field SupplierURL specified. As of now, this at least makes the label blue and clickable, but when I click on it I get an error saying "Unable to open SupplierURL. Cannot open the specified file." Ideas? Thanks.
Question by:horstuff
    1 Comment
    LVL 4

    Accepted Solution

    In the OnCurrent of the form, you need to change the Hyperlink Address for each record.

    Me.LabelQMSuppURL.HyperlinkAddress = nz(Me.SupplierURL)

    Hope that helps.


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now