Add/expand page in report

[marthacasting]

I have a report that needs to show about 20 different fields from 24 records. I have it set up in landscape view, with one record per line (running horizontally). It allows me to show about 15 of the fields, spanning two pages (wide). I don't know how to add a third page to show the remaining fields.
There are no Groupings.

Also, is there a way to "wrap" text in the column header?

Thank you!!!

 

[pbaldy]

Why not keep it on one page and present the data on two or three lines?

 

[marthacasting]

Thank you, but it does not fit!
Each record has so many fields that go across that they span 2 page widths (now need 3 page widths).
And there are so many records that they go onto 2 pages vertically.

When I am in design or layout view, that last 5 or 6 fields on the right all squish together, and the scroll bar at the bottom does not let me go any farther to the right.

I didn't know if I could force a page break, but the info says to insert it after a grouping (which I do not have).

Thank you!!

 

[vbaInet]

I believe what pbaldy is talking about is this:

Textbox1   |   Textbox2   |   Textbox3   |   Textbox4   |   Textbox5   |   Textbox6   |
Textbox7   |   Textbox8   |   Textbox9   |   Textbox10  |   Textbox11  |  Textbox12   |
Textbox13  |   Textbox14  |   Textbox15  |   Textbox16  |   Textbox17  |   Textbox18  | ...etc

...stacked.

On the other hand Excel would handle this better so you could export the query there instead.

 

[pbaldy]

Yes, that is what I meant. If you can't move the controls that way, you may first need to select them all, right click and select Layout/Remove.

 

[marthacasting]

Thank you for your response. I am sorry to admit that I don't understand.
And does this allow it to grow to more than one page?
If I export it Excel, wouldn't I have to (re)format the Excel spreadsheet every time?

Does it mean there is no way to add a page to a report?

Do you know if the text in the heading of a report column can be wrapped?

Thanks again!

 

[vbaInet]

I am sorry to admit that I don't understand.
And does this allow it to grow to more than one page?

I thought what I showed was self explanatory. You stack the controls, one on top of another. 10 controls on one line and another 10 below, all done in the Detail section of the report.

And does this allow it to grow to more than one page?

Does it mean there is no way to add a page to a report?

Reports grow downwards and not sideways. Downwards meaning multiple pages depending on the number of records. Your current setup isn't right.

Do you know if the text in the heading of a report column can be wrapped?

If you set the Can Grow property of the textbox to Yes it will grow downwards (not sideways) to show the full text.

If I export it Excel, wouldn't I have to (re)format the Excel spreadsheet every time?

Create a template in Excel with all the relevant format and export to the template.

 

[marthacasting]

Thank you.
My apologies--I am still learning in Access and am not familiar with stacking controls and codes!

 

[vbaInet]

Ok. Stacking controls is not a concept in Access. It just literally means placing one textbox on top of another. The same way you stack your can of beans.

 

[marthacasting]

In reports and in forms?
I'm still not sure though, how all of the information would be shown.
In the example you showed displayed, would all of those textboxes be related to one record? And each record would be listed underneath each other?

Thanks!

 

[vbaInet]

I suppose you should give it a try and see for yourself. The Detail section repeats for each record.

 

[marthacasting]

Thank you.