I have the code in the OnLoad event for the entire report. I tried to put it into the OnFormat event for the detail section and it shows them all as visible when very clearly some should be not be visible. Any other ideas?
TXT_Health is the health hazard text field and is associated with the left most images. I understand that the health hazard field is no in all records therefore all grey.
Just to clarify its all of the image sets that I am having an issue with not just the one. I copied the code for each set...
Hi! Thanks for welcoming me! I've been getting deeper into the access VBA and I've finally stumped myself lol
They are not yes no fields. There is data in the text fields or no if that field doesn't apply (For example on entry one there is all the text in the warning box)
I am working on an access database for digitizing SDS sheets, and I want images to show or not show depending on the content of the record. I used the following section of code repeatedly for each image set where the red image shows if the corresponding text says anything other than no and the...