Results 1 to 4 of 4
  1. #1
    dniezby is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Apr 2013
    Posts
    183

    Question I feel stupid...but (Hyperlink Field)

    Is there a setting for the Hyperlink Field that shows a "Click here to visit" but the hyperlink it goes to is the one that's entered in the table. Say, the table field has http:/duckduckgo.com in it. When it shows up on the form (for display) I want the hyperlink to say, "Click here to visit".

    Is that possible? I could swear I've done this before but I'm drawing a blank.
    Getting old sucks. LOL.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,728
    A hyperlink in Access is composed of 3 parts separated by # characters. First part is for display text. http://allenbrowne.com/casu-09.html

    For a Hyperlink field type, display text can be specified when hyperlink is entered with Hyperlink dialog. If left blank, Access will default to URL or whatever part 2 is. Modifying data later can be done but not simply.

    Can extract parts of Hyperlink. https://learn.microsoft.com/en-us/of....HyperlinkPart

    I don't use Hyperlink field type. I build hyperlink string with expression. If your hyperlink field is just a text field, then build hyperlink string with expression that concatenates text with field.

    ="Click here to visit#" & [field] & "#"
    Last edited by June7; 01-24-2023 at 04:51 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dniezby is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Apr 2013
    Posts
    183
    oooh..Okay, so use a regular text field and have it displayed with code? I like that approach. Thank you! I'll give it a go.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,728
    Or use Hyperlink field and extract second part to build your customized hyperlink string.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. dlookup makes me feel stupid;
    By Synergy.ron@gmail.com in forum Forms
    Replies: 10
    Last Post: 02-20-2021, 04:24 PM
  2. Stupid Graphs or Stupid User.... you decide
    By rpeare in forum Reports
    Replies: 11
    Last Post: 06-12-2019, 01:02 PM
  3. Duplicating a Report Look and feel
    By Bentley in forum Reports
    Replies: 1
    Last Post: 10-13-2016, 01:13 PM
  4. I feel I am missing something here...
    By Fixer in forum Programming
    Replies: 3
    Last Post: 06-05-2015, 06:28 AM
  5. Replies: 3
    Last Post: 02-09-2010, 03:50 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