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?
LVL 2
MrSlithyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Well if recreating the Report resolves the issue, then perhaps the report was corrupt...
0
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.
0
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...

JeffCoachman
0
Jeffrey CoachmanMIS 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...

;-)

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MrSlithyAuthor Commented:
Well, there's always a first time for experiencing a new MS quirk. Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.