Blank Page with After Section on Group 1

[CindyK]

I've worked with Access for years and never run into this. I have a report with 4 grouping levels. The Print New Page property is set to the AFTER section on the first group footer. (which in design more is the last section on the report before the page footer/report footer). I have NOTHING in the page footer or report footer - but an extra page appears at the END of my report (it's almost always a 3 page report - the three pages work just fine - then comes the blank). (Therefore this isn't the standard page width exceeding the report size problem.)

I have: checked margins - there's no spillovers. Checked for some odd can grow/can shrink setting - nothing weird. The report has no subreports, no images..

I tried taking out the property setting and doing it via VBA code comparing the page number to the total page numbers - saying if I was on the second to last page, don't force the new page. It still forces the new page.

I've got no keep togethers on (I set them all to NO) I have no weird height properties in any of the sections. I am going on 3 hours of different attempts - dare I admit that... including starting the report all over again just in case something weird got corrupted (this is happening to two reports).

However, I AM doing something weird with this report - which might be connected but it seems highly unlikely. When I print this report, I need 3 copies of it - with different headers on the three copies - CLIENT COPY, FILE COPY, FINANCE COPY. After fiddling with this I discovered a rather fun solution of creating a table with those three entries in one field and then adding that table to the underlying report query with no join line (which consists of a union query and this new table). Results in 3 outputs per record - 3 different headings, which is used as my group header/group footer. I'm also using a where clause that gets generated when the report is requested - nothing fancy - just gets added to the OpenReport method.

(I never know how long this report will be - the number of copies gets changed in a console before printing ... a number of what-if situations made me think I had found the easiest solution to the different "copy" headers.)

I've checked the query output being used in the report - it's clean - only 3 records per item. I've tried grouping on the 2nd group footer instead of the first, same problem...

I've tried page breaks in the group footer. Same problem.

Anyone have any other ideas?

Many thanks - sorry for being so long but I know this is a fairly common problem in Access - but this time I've tackled every reason I've ever run into before!!!

Cindy

 

[BobStubbs]

I have seen this problem in one of my reports, but the 'other way round' ... I get the blank page when I use the 'Force New Page Before Section' option!

Try these changes:

-- Choose 'Force New Page Before Section' instead of 'After Section' and see what happens

-- If you have items in the Report Header, but not in the Page Header (or vice versa) try swapping these round

I agree this makes no sense - but in Access I think you just have to fiddle with settings sometimes until something works!


Bob Stubbs

 

[CindyK]

Bob - I hadn't tried setting the page break before the section, assuming I would then get a blank first page. BUT - that suggestion was right on target, did the trick (with no blank first page).

Many thanks.

Cindy

 

[BobStubbs]

I'm glad this helped. When I think about it, my guess is that Access has some 'intelligence' in report formatting, so that you don't get the expected blank page before the very first section. However, this process probably gets confused in a complex report, leading to the blank page problem which you found.

Kind regards
Bob


Bob Stubbs