Display an image instead of the checkbox tick box in report

[Fionfion]

Hi all,

I have a table with a checkbox field - I'm trying to generate a report that displays an image if the checkbox is checked,

my table looks like this:

customer checkbox


A -1
B 0
C -1
D 0

and I want my report to look like this:

customer
A
B
C
D

Is that possible? Thanks!!

[ranman256]

in the query join the data table to the talbe with the image (or in the same table), and show the image if checked:
ShowImg: IIF([chkBoxFld],[imageFld],null)