Switch on/off image on Report

[pekajo]

Hi,
I am printing membership cards with a logo(Image).
However we use the same A4 card sheet over and over (as we may only print 2 at a time) so the the top of the sheet may have a couple of cards missing. So the next time we start to print on maybe the 3rd position on the sheet. (Dangerous I know!)
I can use the Conditional formatting to stop data printing until the required start position, however there is no Conditional Formatting on an Image so it prints the image on the blank spots.
I have tried to use .visible but cannot seem to get it to work.
Any I ideas would be appreciated.

Regards
Peter

 

[pbaldy]

You can use code in the detail section's format event. It would look like like:

http://www.baldyweb.com/ConditionalVisibility.htm

Probably using the same test you'd use for conditional formatting.

 

[theDBguy]

Hi Peter. Check out this demo. Hope it helps...

 

[arnelgp]

there must be a code in your report that skips the 1,2 line or maybe a blank record for 1,2 lines that's why it image is still printing on that line.

add a box control with Normal background that will cover the entire 1 card.
set its visible property to No.

add code to the Detail section Format event.
the code should check if any field (surname or firstname) is blank, make the box visible.
if not blank, make the box invisible.