MrSlithy
asked on
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?
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?
Jeffrey Coachman
Well if recreating the Report resolves the issue, then perhaps the report was corrupt...
ASKER
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.
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
You have reported non of these things, so perhaps the report was corrupt...
JeffCoachman
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well, there's always a first time for experiencing a new MS quirk. Thanks.