Results 1 to 4 of 4
  1. #1
    SierraJuliet's Avatar
    SierraJuliet is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2017
    Location
    Earth
    Posts
    211

    Show image on form

    How do you setup a form field to show an image using the hyperlink information from a text box field on the same form.

    Example:
    1. Desired area to show an image.


    2. Hyperlink text box containing the link for the image.
    3. End result is to show image from hyperlink field or similar method.

  2. #2
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    For images, you use an image control and set its picture property to the location of the image file. Note that it's not advisable to store images as objects in your table (which I am only guessing you don't because you refer to a hyperlink). However, the property setting is usually a drive path, not a hyperlink. I'm not sure I see the sense in trying to get the picture path property from a control that in turn, has to get the link information from somewhere else.

    It might be beneficial for you to research image control for Access.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    SierraJuliet's Avatar
    SierraJuliet is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2017
    Location
    Earth
    Posts
    211
    The reason for referencing a hyperlink is to prevent loading images into the database when the link to the source image/file is good enough. I am merely looking for a way to simply "preview" the link in an image box if possible. Essentially the image box should evaluate the hyperlink value from text box and present the image on the form without storing the image itself.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    A hyperlink type field won't work naturally with Image control. Understand that an actual hyperlink string is composed of 3 parts. Code would have to extract the file path part. I am not sure the hyperlink field is compatible with migration to MSSQL or MySQL.

    Just use a normal text field with path to the image file. Then bind Image control to that field. Review https://www.accessforums.net/showthread.php?t=73766. Post 17 shows examples of how to use expressions in Image control.
    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. Show image only when field has a value
    By themushroomking in forum Programming
    Replies: 11
    Last Post: 07-18-2016, 05:54 AM
  2. Cannot show the link image steadily
    By pencheng in forum Access
    Replies: 4
    Last Post: 07-18-2016, 03:15 AM
  3. Replies: 5
    Last Post: 07-02-2014, 12:15 AM
  4. Combo Box value hide/show Image
    By alyon in forum Access
    Replies: 7
    Last Post: 12-13-2012, 09:48 AM
  5. Show a new image per record in a form
    By Bert Colourama in forum Forms
    Replies: 0
    Last Post: 09-25-2008, 05:22 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