conditionally show images on report

[jillrein]

I have a report based on a query which has 7 fields set to true or false. I want to show ticks on my report where the field is true and nothing where it is false. I know I could use checkboxes but I want big green ticks so am using an image. I thought I could set the image.visible property to =IIf([module1]=False,yes,no) but I can't and I don't know how else to do this. I would be very grateful for any help.

 

[PaulO]

I would do the following:-

1. Create a table called TicksAndCrosses to store two records (each with two fields e.g. Value; Image)
   • The first record is for the positive (0; Tick)
   • The second record is for the negative (1; Cross)
2. Read the Values into the report via query as normal
3. Next to the text box containing the Value introduce a new bound object frame with a dlookup formula in it to pull in the required image from the new table based on the value displayed in the text box.
4. The formula will be something like this:-
   • =DLookUp("[Image]","[TicksAndCrosses]"," [NameOfTextBoxInReport] = [TicksAndCrosses]![Value] ")
   • This will look up and display the correct image based on the value of 0 or 1 in the report.
5. You can then size the frame and stretch the image as required.

 

[jillrein]

Many thanks Paul, a great solution.

Jill