How to keep the fields from printing on a separate page

[Leissa]

Hi. I have a report which is set out in columns containing my data (a bit like a newspaper). There are three columns to the page, the first two columns expand as the data is entered. The problem is with the third column. I have a label and then underneath that a subform. What is happening is that depending on how much data is entered in the first two columns (both text boxes), the subform is printing on a second page,but leaving the label on the first page(even when there is still enough room in that third column. How do I get it to stay on the first page and only expand to the second when there is no space left on the first page?

I hope this makes sense!

[zmbd]

As far as your subreport is able to tell, it has ran out of space on the current page, hence the second page.
I would suspect the reason the label didn't move with the subreport is due to either it not being attached (as in a page/group header) or is narrower in width than the sub.

There are not very many fixes here.
Check the Margins settings
(ACC2010)
Open the report in design mode.
In the ribbon, look for "Report Layout Tools"
"Page Setup" tab
"Page Size" group
"Margins" dropdown tool
[Narrowest] option

Also while here, check the "page layout" group settings, especially the "Page Setup" (you can set margins here (^_^) ).

To test that second hypothesis:
(ACC2010)
Open the report in design mode.
<ctrl><left-click> both the label and the subform
In the ribbon, look for "Report Layout Tools"
"Arrange" tab
"Sizing & Ordering" group
"Size/Space" dropdown tool
[To Widest] option
Save

This will set the width of both controls to the widest of the two; thus, same widith (^_^).

Now run your report.
The label should now move with your subreport when it pushes to a new page.