Image on report

[Ron]

On a report that prints labels, I want to be able to
toggle an image off and on based on whether their order
is paid.

The query behind the report calculates 'balance due' and
basically if 'balance due' equals zero, I want to see the
picture.

I've done this on forms, but don't see where to stick it
in on the report.

Thanks,
Ron

 

[fredg]

On a report that prints labels, I want to be able to
toggle an image off and on based on whether their order
is paid.

The query behind the report calculates 'balance due' and
basically if 'balance due' equals zero, I want to see the
picture.

I've done this on forms, but don't see where to stick it
in on the report.

Thanks,
Ron

Add the image to the label using an Image control.
Code the Report Detail Format event:
ImageName.Visible = [BalanceDue] = 0