Report only prints 6 pages

[Laurel]

I find I am unable to create a report that will print more than 6 pages.
AND, if I shorten the detail area (bring the footer up close to the detail),
it will print even fewer pages.

I have created a new, empty database.

I have created one table, with a first and last name as columns.

I have entered 11 rows in that table.

I have made a report with a record source that selects all of the rows in
that table - no criteria - nothing fancy.

If I put the first_name and last_name in the page in the Page Header
section, the report will print from 2 to 6 of the rows, depending on how
much space I have between the detail and Page Footer sections. The more
space I have, the more pages print, but never more than 6.

I created this simple situation because I bumped into the problem in a
complex database that has plenty of reports that print everything just fine.
Am I right that something must have happened to Access itself???????

HELP!!!

 

[tina]

why are you putting the FirstName and LastName controls in the Page Header
section? if you want a separate page for each name (record) in the table,
then group on the two name fields combined, add the name controls to the
*group* Header section, and add a page break control to the *group* footer
section.

hth

 

[Laurel]

1 - I did this (most of it) but the number of rows that print is still
dependent on the amount of space between the "Detail" and "Footer" bars. In
this case, now, the bars are labeled "Expr1 Detail" and "Expr1 Footer". In
other words, if the bars are very close together, only one row of data
prints. If they are very far apart all of the data prints. In my real
report, I can't put the bars far apart, becaue then my subreport that I have
in the detail prints over and over.

2 - How do I add a page break control in the group footer section?

 

[tina]

sorry, i've no other suggestions for you. good luck with it.

 

[Laurel]

Well, I still don't know how to "add a page break control," (could you tell
me that?), but I did find the "force a new page" property for the new Exp1
footer. When I turned that on "after the section," it fixed it!!! AND it
fixed another problem I had, which I hadn't mentioned, where the subreport
would repeat its rows over and over until the space was filled. After I put
the force a new page on the main report footer, the subreport printed its
rows only once.

I'm glad I got it fixed, but I'm not glad that it's so flakey. I would be
hard pressed to state the rules that should be followed - particularly when
other reports work OK when structured without the group.....

Thanks for the suggestion.