Results 1 to 4 of 4
  1. #1
    kraftk is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    4

    Display Image based on Value

    i want to display an image on a report based on a value in a query i have. If the result in the table is yes then display the image, if it is no then don't display the image,. if it is N/A don't display the image. Thoughts about how to do this?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    Where is image? Attachment field or external location?

    Code in report Format event can dynamically set visibility of control. However, control will still occuply space.
    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
    kraftk is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    4
    File is stored in the database folder on the C drive.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    Are you using an Image control to display? Images are jpg, png, bmp? See post 17 in https://www.accessforums.net/showthr...t=73766&page=2

    Us an IIf() expression to conditionally display image.
    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. Replies: 10
    Last Post: 02-25-2019, 07:36 PM
  2. Do not display box if no image pulled in
    By duece7 in forum Access
    Replies: 4
    Last Post: 12-11-2015, 03:55 PM
  3. Image controls fail to display
    By GraeagleBill in forum Reports
    Replies: 5
    Last Post: 09-06-2012, 12:28 PM
  4. Problems with image display, please help
    By lherndon in forum Forms
    Replies: 2
    Last Post: 04-20-2012, 12:42 PM
  5. Display image based on combobox selection?
    By 10 Gauge in forum Forms
    Replies: 2
    Last Post: 09-15-2011, 07:42 AM

Tags for this Thread

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