Create working URL in Textarea in MS Access using VBA

Posted on 2006-05-09
Last Modified: 2008-03-04
Yes, I was wondering if anyone knew how to create a working URL in a textarea
of MS Access. Thanks!
Question by:scubakgd
    LVL 54

    Expert Comment

    The only option I know is to define a hyperlink table field and place that on a form or to insert a hyperlink directly on a form from the menubar.
    A "normal" textbox won't support clickable URL's

    LVL 2

    Accepted Solution

    Text area of a form or a table?  

    On a form, you can use the HyperlinkAddress property of a label:

    Private Sub Form_Load()
        Me.Label1.HyperlinkAddress = ""
    End Sub

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    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