Detect the first page of group

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tran Hong Quang - 04 Feb 2006 18:03 GMT

Hi,
I se "Force New Page" = "After Section" . So that each group will be
started from a new page.

I want display something on each first page of every group. How to detect
that current page is the first page of a group?

Thanks

Tran Hong Quang

Reply to this Message

John Spencer - 04 Feb 2006 18:24 GMT

Add a control to the detail level
NewControl
Name: CountItems
COntrol Source: =1
Running Sum: Over Group

In the format event of the section header, test CountItems to see if its value
is 1. If it is then do something to show your control, message, etc.

> Hi,
> I se "Force New Page" = "After Section" . So that each group will be
[quoted text clipped - 6 lines]
>
> Tran Hong Quang

Reply to this Message

Marshall Barton - 04 Feb 2006 19:46 GMT

> I se "Force New Page" = "After Section" . So that each group will be
>started from a new page.
>
> I want display something on each first page of every group. How to detect
>that current page is the first page of a group?

Either you've been too vague or the simple answer is that,
since you've used ForceNewPage, the group header section
will appear on the first page of the group and you can
display whatever in that section.

Signature

Marsh
MVP [MS Access]

Reply to this Message