How to change the height of the report form.

[trident]

I have a data form that is made up of several entry sets, when I created a report and went to the design view, the length can only be up to 21 inches. I like the whole report to be made in 1 report form, how can I make this even longer. so that when I print the report, it will print in A4 in several pages, it will print page 1-8.



thank you for your assistance.

Trident

[June7]

Form and report objects are limited to 22 inches in design. Period. Cannot be changed.

[trident]

June7, Thank you for this clarification, this has a connection with my other inquiry,How to print several reports one after the other

the reason for this question is that since it is still in a design phase, a lot of things are updated,removed and added, if the addition is at the 1st page or before the last page, I need to open all the report forms just to re-arranged the whole report.
or if it is already working properly, i need to open all the reports just to print the whole report and collate them.

I need 1 button probably in the form or 1st page of the report, that when you click, it will click the next pages of the the report.

Thanks again for the clarification and looking forward to your reply.

[June7]

Don't really understand what you want. A report's default open mode is direct to printer. All pages will print. Even if the report is opened to screen, all pages will display and can be navigated.

So what do you mean by 'several reports'? What do you mean by 'click the next pages of the report'?

[trident]

Instead of 1 report with 8 pages when I print, I have to create 8 reports, 1 page 1 part of the report since the data will not fit 1 report.

[June7]

Then you will need 8 DoCmd.OpenReport commands one after the other or one command in a loop structure. If each report has names like MyReport1, MyReport2, MyReport3 ...

For n = 1 to 8
DoCmd.OpenReport "MyReport" & n, , , "some filter criteria here"
Next

[trident]

June7, I will try the same and inform you of the result.

Thanks again.