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?
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?
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.
File is stored in the database folder on the C drive.
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.