Conditional Image in a Report

[Guest]

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?

 

[Guest]

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

 

[Guest]

That worked. Thanks!
--
Amy E. Baggott

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

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?