page break on new records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a recordset that returns anything that's marked incomplete. The
recordset returns the following 3 records:
ORDER1 ITEM1 Qty2
ORDER1 ITEM1 Qty3
ORDER2 ITEM2 Qty1

Is there a way to insert a page break after the 2nd record (or when
OrderNumber is changed) on the report so the first 2 records (both for
Order1) in the first page, and 3rd record (Order2) goes into 2nd page?


Thanks
 
If you have it grouped by "Order Number" and you have a group header, one of
the properties in that group header is "Force New Page".

Rick B
 
Rick,
Thanks for ur fast response. I am using Access 2000, it's selected to
group using OrderNumber in the record source. Can you tell me where I can
specify Force new page?

Thanks
 
In your "grouping and sorting" dialog box (it is on the menu) there is a
se;ection to include a header and footer. Turn on the header. Once your
group header is displayed, you can right-click on the little gray square to
the left of the header (still in design view) and select "properties".

Hope that helps.

Rick B
 
Back
Top