Forcing a new report page from VBA?

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

re: Forcing a new report page from VBA?

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

Show or hide the pagebreak control.
-Tom.

[color=blue]
>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.[/color]

re: Forcing a new report page from VBA?

RE/[color=blue]
>Show or hide the pagebreak control.[/color]

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

re: Forcing a new report page from VBA?

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.

[color=blue]
>RE/[color=green]
>>Show or hide the pagebreak control.[/color]
>
>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.[/color]