Results 1 to 3 of 3
  1. #1
    Perfac is online now Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Gauteng Johannesburg
    Posts
    323

    Display of Hyperlink on report


    Click image for larger version. 

Name:	Hash.png 
Views:	12 
Size:	24.2 KB 
ID:	41378
    The field displaying the website and email address, show the # sign and other extras. How do I get the report to display the website as I captured it.

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,863
    One way would be to set the Is Hyperlink property of the control to yes in report design view, which will make it a clickable link in report view but not print preview. Don't know if that's what you want though. If not, you should state if the table field is a hyperlink type or if you're doing this some other way.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    54
    And if you decided that showing a full URL on the report might be cumbersome especially for an extra long URL here are a couple more options for the links...

    --- Approach 1 ---
    Put in 2 fields with DataType of Short Text and perhaps call them WebName and WebURL.
    Put in data such as:
    WebName of Google and WebURL of http://www.google.com
    WebName of Google Maps and WebURL of http://www.google.com/maps

    On the report put in a textbox control with IsHyperlink of Yes and ControlSource of =[WebName] & "#" & [WebURL] & "#"
    Then on the report the links will look like this:
    Google
    Google Maps
    And records with no data in the WebName and WebURL fields will still appear blank.

    --- Approach 2 ---
    Put in 1 field with DataType of Short Text and perhaps call it WebURL.
    Put in data such as:
    WebURL of http://www.google.com
    WebURL of http://www.google.com/maps

    On the report put in a textbox control with IsHyperlink of Yes and ControlSource of ="View#" & [WebURL] & "#"
    Then on the report the links will look like this:
    View
    View
    And records with no data in the WebURL field will still appear blank.
    J. Paul Schmidt - Freelance Web and Database Developer
    Sample Database on the Web
    Sample Access Database

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

Similar Threads

  1. Replies: 5
    Last Post: 06-13-2018, 05:53 PM
  2. formula to display the address of a hyperlink
    By markjkubicki in forum Programming
    Replies: 2
    Last Post: 11-30-2016, 08:34 AM
  3. Copying hyperlink display into new column
    By pmontalt in forum Access
    Replies: 5
    Last Post: 05-13-2014, 08:34 AM
  4. Display URL hyperlink images in form
    By cwillwright in forum Forms
    Replies: 1
    Last Post: 10-11-2012, 08:55 PM
  5. Display hyperlink as Icon??
    By Rosier75 in forum Access
    Replies: 2
    Last Post: 03-08-2011, 06:44 AM

Posting Permissions

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