Conditional Image in a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
That worked. Thanks!
--
Amy E. Baggott

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


TerryC said:
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

Amy E. Baggott said:
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?
Click to expand...
Click to expand...
 
Back
Top