Results 1 to 7 of 7
  1. #1
    .:SoundWave:. is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Dec 2010
    Posts
    11

    Question "Clickable" title in report

    In a Report, is there any way to embed a hyperlink within a text box that is pulling data from a field other than the field that a hyperlink is stored in? For example, my current report has a textbox (txtTitle), and then beneath it another textbox that displays a clickable hyperlink, so the Report ends up looking like:

    Customer Review: Random Blog Title

    Source: www.linktorandomblog.com/post/

    I would much rather have it look like the BBCode equivalent of:



    Customer Review: Random Blog Title

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    more than likely, the best way to do this would be to store the addresses and their relevant titles in a table so they can be looked up when needed. Then simply use either a direct hyperlink in the control's properties for data type, or use the:
    Code:
    application.followhyperlink "ADDRESS"
    behind the click event, with the caption or control source being used to display the titular words (depending on type of control you use).

    if you use the latter method, with code needed, it would be wise to use a transparent button and set the ''cursor on hover'' property to ''hyperlink hand''.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Don't forget that a Report is really just a piece of paper and not interactive.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by RuralGuy View Post
    Don't forget that a Report is really just a piece of paper and not interactive.
    What do you mean Allen?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If the OP is really talking about a *Report* and not a Form, then coaxing it into being interactive would be a trick.

  6. #6
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by RuralGuy View Post
    If the OP is really talking about a *Report* and not a Form, then coaxing it into being interactive would be a trick.
    It works just like a form with regard to all the advice I gave Allen...or are you talking about something else?

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I will have to assume this is in preview mode and I was not aware of the fact that it could be interactive.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-19-2010, 09:16 AM
  2. Replies: 8
    Last Post: 02-24-2010, 01:49 PM
  3. Populating a "Text" field in a Report
    By two_smooth in forum Reports
    Replies: 20
    Last Post: 02-19-2010, 11:25 AM
  4. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums