Access 2003 Report only prints first page. Why?

Report is based on a query. When I run the query, it shows 52 items matching the query.

The report prints only the first 32 items.  More specifically. The report prints only the first page.  There is no second page available in the print view, either.  If the paper is switched from letter to legal, all 52 records print - -  -or more than 32 anyway.  So something is telling the report to print only page 1.

If I create a new report, and add all the element from the old report - The query to base it on, the query items, headers and footers, it prints as you would expect.

I even tried comparing the 2 different report properties and I can see no differences between reports.  So I got by it by placing this report in place of the one that appears to be mis-firing.

Oh yeah, I did a compact and repair. No change.

What else should I look for?
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
<I have never experienced that sort of file corruption in Access. >
Yep, if you keep everything up do date and do regular maintenance, you will trouble-free for the most part.

But every once in a while Access, or the computer, will "hiccup" and cause a problem.
Some of these issue cannot be fixed by the normal means, and the report/form will simply need to be recreated from scratch.

But to be fair, lets see if another Expert chine in with more info...


Jeffrey CoachmanMIS LiasonCommented:
Well if recreating the Report resolves the issue, then perhaps the report was corrupt...
MrSlithyAuthor Commented:
yeah, I know I am crying over spilt milk but it kind of bugged me. and I have never experienced that sort of file corruption in Access.
Jeffrey CoachmanMIS LiasonCommented:
There have been posts where opening the report in Print Preview causes problems in printing, ...but this is typically because of graphics rendering, or a complex recordsource, or simply lots of records...

You have reported non of these things, so perhaps the report was corrupt...

MrSlithyAuthor Commented:
Well, there's always a first time for experiencing a new MS quirk. Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.