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

Forcing a new report page from VBA?

P: n/a
I *know* I've done this, but can't remember what I did.

The situation is that we have a report that lists many people per page except
when a "GotPix" flag is true; then we want that person to have the page all to
themself.
--
PeteCresswell
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Tue, 21 Sep 2004 01:05:09 GMT, "(Pete Cresswell)" <x@y.z> wrote:

Show or hide the pagebreak control.
-Tom.

I *know* I've done this, but can't remember what I did.

The situation is that we have a report that lists many people per page except
when a "GotPix" flag is true; then we want that person to have the page all to
themself.


Nov 13 '05 #2

P: n/a
RE/
Show or hide the pagebreak control.


Bingo! Thanks.

At the risk of turning into a tarbaby on you... any idea how
to tell if it's going to start a new page anyhow on it's own?

Seems like there's room for double page feeds here... I fooled
arount with Me.Pages a little, but didn't get anywhere.
--
PeteCresswell
Nov 13 '05 #3

P: n/a
On Wed, 22 Sep 2004 00:43:59 GMT, "(Pete Cresswell)" <x@y.z> wrote:

Not really. Perhaps I would use the Format event and Me.Page.
-Tom.

RE/
Show or hide the pagebreak control.


Bingo! Thanks.

At the risk of turning into a tarbaby on you... any idea how
to tell if it's going to start a new page anyhow on it's own?

Seems like there's room for double page feeds here... I fooled
arount with Me.Pages a little, but didn't get anywhere.


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.