Results 1 to 3 of 3
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618

    Display of Hyperlink on report


    Click image for larger version. 

Name:	Hash.png 
Views:	18 
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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    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.

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
  •  
Other Forums: Microsoft Office Forums