Extra space before my table

Question

When selecting specific columns and placing them in a report, they crawl to the left, leaving a large space. This leads to printing a blank page and then the data. How do I solve this problem?

Answer 1

If the number of columns you wish to include in a tabular report is such that, with the default control width, they will exceed the width of the page, less margins, then you will need to resize each control, and move them leftwards, so that they can all be accommodated in the design area.  By setting the CanGrow property of each control and of the detail section to True (Yes) text will wrap within the controls where it cannot be accommodated within the width of the control.

Having reduced the width and repositioned each control, then drag the right edge of the design area so that it fits within the page width, less margins.

To reduce the amount of wrapping you could of course reduce the font size of each control, but be sure that this does not make reading of the report difficult.  Another option would be to set the Page Layout to Landscape in the Page Setup ribbon to allow wider and/or more controls per page width.

For an example of a report set out in the way described above, you might like to take a look at DatabaseBasics.zip in my public databases folder at:

https://onedrive.live.com/?id=44CC60D7FEA42912%21169&cid=44CC60D7FEA42912

In this little demo file the first form in the section on 'entering data via a form/subforms' includes an 'Open Report' button, which opens a report in print preview.  You'll see how, where necessary, data has wrapped over two lines in a column.

Answer 2

Perhaps screenshots and more details could help us picture the scenario well enough to attempt some suggestions to try.

Controls don't move when placed on reports, so let's start there. Show us where and how you place the controls and what happens when viewing the results in Print Preview.