By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,977 Members | 1,352 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,977 IT Pros & Developers. It's quick & easy.

Report page break

P: n/a
Dear reader,

Is there some VBA code to place or remove a page break on the bottom of the
report header section?

In some cases only the header section of the report has to be printed in
that situation no page break is required and in other cases I need a page
break on the bottom of the report header section.

Thanks for any help or suggestion.

Kind regards,

Simon van Beek
Oct 3 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 3 Oct 2007 22:14:00 +0200, Simon wrote:
Dear reader,

Is there some VBA code to place or remove a page break on the bottom of the
report header section?

In some cases only the header section of the report has to be printed in
that situation no page break is required and in other cases I need a page
break on the bottom of the report header section.

Thanks for any help or suggestion.

Kind regards,

Simon van Beek
And what is the criteria? How does the report know when to page break?

Add a PageBreak control to the report.
Then use code in the Format event of the Report Header.

PageBreakControlName.Visible = Some criteria = True

You'll need to change
Some Criteria = True
to whatever the actual criteria is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.