Print each vendor's record on it's own page

[Don]

I am trying to print only one Group header's (VendorName) records per page on
a report in Access 2007 (upgrading to this product was a mistake - can't find
anything). When I print, all Group records seperate and group but they print
together on the same page eventhough I set the properties for the Group
Header to force a new page after Section. How can I accomplish my goal?


Thanks,

Dennis

 

[Evi]

Are you sure you don't want the Force New Page to be either Before Section
in the Page Header or After Section in the Page Footer.

(Can't say I like what I've seen and heard of Office 2007 so far. I got sent
a spreadsheet and word document in 2007's new format. I would have had to
install some dodgy piece of Microsoftware before I could open them - and I'm
not doing that until I see what bugs that is causing to existing
installations.)

Evi

 

[Don]

Maybe if I rephrase the question. I have a report that does not use the
report or page header and begins in the group header. In this section I
included just the group field (which is VendorNumber) and the vendor name. In
the next section I have the records that relate to the group. And in the page
footer I have no vields other than page number.

The problem I am having is I cannot get the page to break before or after
the VendorNumber changes. In fact, I cannot get any break. All 400 records
group under the VendorNumber but no page breaks. I have set the properties on
the group header to force a page break before, after and tried before and
after to no avail. I also tried to set the page footer’s properties to force
new page before and after. No matter what I do I cannot get a page break. The
report is one solid 400 record page grouped by VendorNumber. How can I solve
this problem?

 

[Evi]

Have you tried using the Group Footer (not the page footer)?
And make sure that in the Sorting Grouping box you have not set the Keep
Together bit for VendorNumber to Whole Group.
Do you have Page Break controls in the report as well as using the Keep
Together. (You may need to use the Object box (if Acc2007 still has such an
animal) to check for this. They are difficult to see.
Have you set the CanGrow/CanShrink Property of the Details Section to Yes?
Are your details in a subreport?

It may be an Acc2007 issue but I can't believe that they've managed to muck
up this as well!
Evi