Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Kansas City
    Posts
    103

    Unanswered: Establishing Hyperlink on Form

    How can I create a functioning hyperlink on a form while displaying the sting value from another form field rather than the actual hyperlink's path? I'm working in Access 2003 and have a form sourced to a query which contains the hyperlink/path and other data elements for each record.

    I've tried using the 'mouseover' event property with

    Me.My DisplayText.Value = Me.MyHyperlink

    but with little success.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think you want to look up "HyperlinkAddress".
    Let us know if you find the answer or not!
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2002
    Location
    Kansas City
    Posts
    103
    Although my hyperlink address was in a table and being referenced by a query and subsequently by a form control, I realized that the display text of my hyperlink needed to be added to the address in the table rather than trying to concatenate the two hyperlink parts in a calculated form control.

    My hyperlink now works and displays the text I needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •