Invisible Text boxes cause the page to break - Why?

  • Thread starter Thread starter FMFF
  • Start date Start date
F

FMFF

I set the visible property of ALL the new textboxes I added to an existing
report to be FALSE.

What used to be a one page report now became a two page report with the
second page being Blank with footers.

How do I ensure that the page breaks only when the above textboxes are
visible?
 
You aren't providing us with much context of your setup and why you are
making stuff invisible.

My guess is that you could put all of the controls you want hidden in a new
section and make the section visible or invisible.
 
98% of the controls in the report are bound and get their values from an SP.
We refer to each report as a Production Ticket. We have one ticket for every
order number.

The new text boxes I added are "Instructions" for various user groups who
will handle the tickets. These text boxes get the values from a web service.
I conditionally break the pageby having a Page Break Control (visible = true)
and make the appropriate text box visible if they have any value.

When there are no instructions for a ticket, we simply do not want to print
the second page at all. So I make all the textboxes and the PageBreakControl
invisible. Still I get a blank page with just the footer for a ticket with no
instructions.

Given this context, how best to handle this?
 
I would try what I suggested. Consider adding a new detail section footer by
creating a lowest level sorting and grouping section based on the primary key
of your report's record source. Put all of your controls you want to hide in
this section. Then use code to determine if there is anything in the controls
and if not, set the section to invisible.
 
Your suggestion worked. Thanks a lot again.

Duane Hookom said:
I would try what I suggested. Consider adding a new detail section footer by
creating a lowest level sorting and grouping section based on the primary key
of your report's record source. Put all of your controls you want to hide in
this section. Then use code to determine if there is anything in the controls
and if not, set the section to invisible.
Click to expand...
 
Back
Top