Conditionally hide report elements

[Guest]

I have a report used to generate a sheet of floppy diskette labels, but we
frequently print less than a complete sheet, and then begin the next time in
the middle of the sheet. As a workaround, when creating the labels, the form
prompts the user for starting position of the first label to be printed, then
the temporary dataset is created with an appropriate number of blank records
to bump the first real label down.

The trouble is, the labels include a corporate logo, and I'd like to hide
the logo for the blank labels. Do I need something in the OnFormat event for
the Detail section, or should I be looking at the OnPage event of the report?

TIA

 

[AlCamp]

Sheldon,
The OnFormat event for the detail section will do it.
You'll need some value in the data to hang your logic on.
Such as... if the Label Title is Null, then the logo Visible=False.
hth
Al Camp

 

[Guest]

This seems to hide the logo on every label, not just the blank ones. Is it
not possible to show only some copies of the label? Do I need to change the
report to do the layout programmatically instead of adding blank records to
the beginning of the dataset?

TIA
Sheldon Slade

 

[Duane Hookom]

Does your code set the logo back to visible?

 

[AlCamp]

Sheldon,
I'm going with Duane on this one... since you print the blanks first,
you'll need to restore the visibility...
OnFormat...
If IsNull(LabelTitle) then
Logo.Visible = False
Else
Logo.Visible = True
End If
Al Camp

 

[Guest]

Duh. No. That's exactly what I'd overlooked, thanks.

Sheldon