New Page (Help !!!)

[staines]

Hi all hope someone can help

I’m new to Access so hope I make sense. I’m writing a report that lists products, what I would like is for it to print so that if it’s in the middle of the detail lines start a new page.

I probably haven’t explained my self very well so will try to illustrate

This is what happens at the moment

Paint
Red
Blue
Gray

Paper
Thin
Card
Spotted

Phones
Home
------------ new page --------
Mobile

But what I would like is

Paint
Red
Blue
Gray

Paper
Thin
Card
Spotted
------------ new page --------
Phones
Home
Mobile

Thanks for any help !!!!!

 

[trucktime]

Report

Try this.

Open the report in design view, go to view/sorting and grouping.
Select the group, and in Properties on the last line, set
Keep Together to Whole Group.

 

[staines]

worked like a dream !!!

Thank you