I have a checkbox field set up for products that have a particular feature. For instance, if the product has a lifetime warranty, the checkbox is checked. On my report, I have the checkboxes displaying and they either show the check or not, but the text and everything is still there on the ones that are not checked. I know I can hide it unless there is a value and only show it if it is checked, but how would I go about displaying a logo if the box is checked? Essentially, what I want to do is have a "Lifetime Warranty" logo display on the products that have a lifetime warranty, and the ones that do not, just show nothing...
to be more specific, there are 2 options (checkboxes), of which only 1 will be checked (if any). If a product has Warranty A, I want to display image A....if the product has Warrany B, I want to display image B...if the product has our standard warranty, then I want to display no image. So I have 2 ideas on how to accomplish this: First, I can add an image for each of the warranties to the report where I would want it to show and set the visibility to no, then somehow code it so that if checkbox A is checked, then set image A visibility to yes and if checkbox B is checked, set image B visibility to yes. The other idea I have is to have an image box with visibility set to no, then have some code that says if checkbox A is checked, set control source to "path/imageA.jpg" or if checkbox B is checked, set control source to "path/imageB.jpg" (Possibly with an IF THEN statement?) ...I'm not very good with code yet, so if anyone could offer some help with this or show me a better way, it would be greatly appreciated. Thanks!