Results 1 to 3 of 3
  1. #1
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    Using hypertext links in database design.

    I'm using the hypertext field for book titles so they can be linked to the Internet. Now I'm coming across books that are not on the Internet, and thus, if used in a hypertext filed, it obviously leads to an error message for the end user. The only solution I can think of is creating just a plain text field specifically for those titles w/out an Internet presence. However, that will end up creating blank fields in the database, something I always hope to avoid. Any suggestions?

  2. #2
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    I would just use an N/A to fill in the blank ones, But I am fairly new at this. I am interested in some of the more experienced answers as well.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    there is nothing wrong with having blank fields in a table - just means there is no data. Personally I would have two fields, one for book title and one for the hyperlink (Hyperlink text could be a standard 'click here' and the control migh have no borders and a transparent background). If there is no hyperlink then that is the field that would be blank and clicking on it will do nothing. If you wanted to show something you can use the format property to show an alternative message for when there is no hyperlink e.g.

    ;;;"No Web Link"

    Alternatively, hide or remove the hyperlink control from your form and have some code behind the book title (which can be formatted to look like a hyperlink) which checks to see if there is a link and if there is, opens it, otherwise displays a message 'No Web Link' or similar.

    You can even use conditional formatting to change the book title background or foreground or remove the underline based on whether the hyperlink field is null

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

Similar Threads

  1. Replies: 2
    Last Post: 10-02-2015, 10:12 AM
  2. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  3. Database Design
    By intransit2 in forum Database Design
    Replies: 2
    Last Post: 04-12-2012, 02:20 AM
  4. Showing Database Links
    By cbh35711 in forum Access
    Replies: 3
    Last Post: 03-23-2012, 11:45 AM
  5. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 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