Force page break in report

[George Bowyer]

I am using a report to print tickets for clients.

Each client gets seven tickets, which I am printing on a "business card" avery set-up which has 10 "cards" per sheet in a 2 across / 5 down format.

Ideally, I would like to force a page break after each group of seven, so that the whole sheet can be sent to the client.

For various reasons every tticket has to have its own record, and each record has a Ticket Set field and and a Ticket Number field (1-7).

So what I think I am looking for is some sort of code to put in the on format event of the detail which says "if fldTicketNumber = 1 then force new page" - but I can't find anything in the help about code to force a new page.

I can get around it by printing from a query which has a particular set number as a criteria, but that is cumbersome...

 

[scalextric59]

Try this:
if [yourfield]=1 then
me.detail.forcenewpage=1
end if