Conditional Image in a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy E. Baggott - 14 Sep 2005 21:10 GMT

I'm creating an invoice report that includes a logo in the page header (the
same for every record). However, if a record meets certain criteria, there
is a second logo I want to display/print next to it -- but only for the
records that meet those criteria. Is there a relatively simple way to do
this?

Signature

Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

Reply to this Message

TerryC - 15 Sep 2005 04:04 GMT

Amy,

Design your report with the second image on it. Set the visible property to
false (makes the image invisible). In the section's "on format" event (the
section that contains the image) add something like:

if (your condition here) = true then
me.[image control name].visible = true
else
me.[image control name].visible = false
end if

Your condition might be [field2] = 5
in which case the first line would read
if [field2] = 5 then

HTH

Terry

> I'm creating an invoice report that includes a logo in the page header (the
> same for every record). However, if a record meets certain criteria, there
> is a second logo I want to display/print next to it -- but only for the
> records that meet those criteria. Is there a relatively simple way to do
> this?

Reply to this Message

Amy E. Baggott - 15 Sep 2005 19:36 GMT

That worked. Thanks!

Signature

Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

> Amy,
>
[quoted text clipped - 21 lines]
> > records that meet those criteria. Is there a relatively simple way to do
> > this?

Reply to this Message