In Access control whether image displays
Posted on 2014-04-14
Have an Access Report where the record source is a table (Tbl_xyz) having 2 text fields.
Tbl_xyz records are:
ID Field 1 Field 2
1 Blue (Null)
2 Green c:\green.jpg
3 Brown (Null)
Would like report to list all records in Detail section, but for record #2 display the image located in Field 2 and then proceed to contents of record #3. So, I inserted an Image Control in the detail section and made the control source Field 2.
By inserting an image control in the detail section, the image frame creates additional space in those lines where there is no image. Is there a way to conditionally make that image frame visible? In other words, records #1 and #3 don't have images. I don't want the space created by the image frame to be visible. Thanks!