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

Reports - position of a control

P: n/a
I have a report which prints a list of products with some (user entered)
text following it.

Often the products listing ends on the penultimate page, with just the
text on the final page. In such a case, I want the last two products to
print on the final page.

Is there a way of knowing the position on the report? So if it is below
a certain point when the last two product prints, then I can push them
onto the final page.

How do I do that?
Thanks
--
Zippy S
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In the Format event of the (Detail?) section, examine the Top property of
the report. If you are already too far down the page and close to the last
record, you can set the Visible property of a Page Break control (it's in
the toolbox) to force the final records onto the next page.

The Top property is in twips, where 1440 twips = 1 inch.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zippy" <Zi*****@thedessers.com> wrote in message
news:oN**************@thedessers.com...
I have a report which prints a list of products with some (user entered)
text following it.

Often the products listing ends on the penultimate page, with just the
text on the final page. In such a case, I want the last two products to
print on the final page.

Is there a way of knowing the position on the report? So if it is below a
certain point when the last two product prints, then I can push them onto
the final page.

How do I do that?
Thanks
--
Zippy S

Nov 13 '05 #2

P: n/a
In message
<42**********************@per-qv1-newsreader-01.iinet.net.au>, Allen
Browne <Al*********@SeeSig.Invalid> writes
In the Format event of the (Detail?) section, examine the Top property
of the report.
That does it. Thank you.
If you are already too far down the page and close to the last record,
you can set the Visible property of a Page Break control (it's in the
toolbox) to force the final records onto the next page.


The Page Break doesn't seem to work in a subreport, which is where my
list is. Do you have another way of forcing the final two records onto
the next page.
--
Zippy S
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.