Previewing a report spanning multiple horizontal pages

[Jim Pockmire]

I have a report that has more columns than will fit on one page. When
setting this up to print as multiple reports, how can I preview the first
(wait for a keyboard entry), then preview the second.

Perhaps there's even a better way.

 

[Allen Browne]

How wide is this report?

An Access report can be up to 22" wide. If you use Letter-sized paper,
portrait mode, with left and right margins of 0.85" or larger, that means
you can actually fit 3 pages "across" your report. Alternatively, you can
fit 2 pages across in landscape mode. It that enough to fit all your
columns?

This approach is much simpler than having to divide it into 2 or 3 reports.
Even the page nubmering is simple. You place a text box on the left-most
"page", with Control Source of:
="Page " & [Page] & " (left)"
Then put another text box on the right hand page like this:
="Page " & [Page] & " (right)"

 

[Jim Pockmire]

I am not sure this will work. I should be able to fit the report within
22", but I need the row headers on each page of the report - is this
possible?

How wide is this report?

An Access report can be up to 22" wide. If you use Letter-sized paper,
portrait mode, with left and right margins of 0.85" or larger, that means
you can actually fit 3 pages "across" your report. Alternatively, you can
fit 2 pages across in landscape mode. It that enough to fit all your
columns?

This approach is much simpler than having to divide it into 2 or 3
reports. Even the page nubmering is simple. You place a text box on the
left-most "page", with Control Source of:
="Page " & [Page] & " (left)"
Then put another text box on the right hand page like this:
="Page " & [Page] & " (right)"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that has more columns than will fit on one page. When
setting this up to print as multiple reports, how can I preview the first
(wait for a keyboard entry), then preview the second.

Perhaps there's even a better way.

 

[Allen Browne]

In report design view, it looks like one wide report.

So, if "row headers" means the first column of the report, you can repeat
this field the desired distance in from the left. For example if you use
0.85" margins left and right, you will need to repeat this column 6.8" from
the left(i.e. 8.5 - 0.85 * 2).

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am not sure this will work. I should be able to fit the report within
22", but I need the row headers on each page of the report - is this
possible?

How wide is this report?

An Access report can be up to 22" wide. If you use Letter-sized paper,
portrait mode, with left and right margins of 0.85" or larger, that means
you can actually fit 3 pages "across" your report. Alternatively, you can
fit 2 pages across in landscape mode. It that enough to fit all your
columns?

This approach is much simpler than having to divide it into 2 or 3
reports. Even the page nubmering is simple. You place a text box on the
left-most "page", with Control Source of:
="Page " & [Page] & " (left)"
Then put another text box on the right hand page like this:
="Page " & [Page] & " (right)"

I have a report that has more columns than will fit on one page. When
setting this up to print as multiple reports, how can I preview the first
(wait for a keyboard entry), then preview the second.

Perhaps there's even a better way.

 

[Jim Pockmire]

I'll give it a try - tnx

In report design view, it looks like one wide report.

So, if "row headers" means the first column of the report, you can repeat
this field the desired distance in from the left. For example if you use
0.85" margins left and right, you will need to repeat this column 6.8"
from the left(i.e. 8.5 - 0.85 * 2).

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am not sure this will work. I should be able to fit the report within
22", but I need the row headers on each page of the report - is this
possible?

How wide is this report?

An Access report can be up to 22" wide. If you use Letter-sized paper,
portrait mode, with left and right margins of 0.85" or larger, that
means you can actually fit 3 pages "across" your report. Alternatively,
you can fit 2 pages across in landscape mode. It that enough to fit all
your columns?

This approach is much simpler than having to divide it into 2 or 3
reports. Even the page nubmering is simple. You place a text box on the
left-most "page", with Control Source of:
="Page " & [Page] & " (left)"
Then put another text box on the right hand page like this:
="Page " & [Page] & " (right)"

I have a report that has more columns than will fit on one page. When
setting this up to print as multiple reports, how can I preview the
first (wait for a keyboard entry), then preview the second.

Perhaps there's even a better way.