General discussion


access report multi +column conundrum

By ironfist03 ·
I have a multi column report in Access 97 that I need to go down and across, but also needs to be able to grow and span multiple pages. I have this as a nested subreport (a report in subreport, and that report is a subreport in another report, did that make sense?). If I have the report as just a subreport it works fine, but the problom is when I make that report a subreport, it looses the ability to grow to a second page if I set it as down and across. If I reset column layout to across then down it works fine. The main report has 24 .5 inch subreports allowed to grow seperated by page breaks. I believe I need VB code to tell when the column has hit the bottom of the page so it knows to make a second page. Anyone run into this before?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by ironfist03 In reply to access report multi +colu ...

come on guys & guyettes,, help me out.. someone must know why this is happening.. see... i've even stepped up the points..

Collapse -

by scmgithd In reply to access report multi +colu ...

This is just a guess, but if you go into the properties of the detail can't you change a settign there? There's an option to force a new page, can grow should be set to yes, keep together set to no.

You sound much more advanced than I am on Access, so I might be stating the obvious. On the other hand, sometimes it works. Good luck

Collapse -

by ironfist03 In reply to access report multi +colu ...

This question was closed by the author

Related Discussions

Related Forums