Setting to avoid printing a report column

[peter2012]

I have a report that fits nicely onto one A4 page.

Then I had to add an ID column to be able to sort by ID (would not sort by ID unless I added the column to contain the record ID numbers, even though the query on which the report is based is sorted by ID).

Because I added another column (on the right hand side) to contain the ID column, it's gone over the A4 size and so prints a second page with the ID column on it.

So I hid the ID column, but a second page still prints, just with nothing on it.

I don't want to shrink any of the columns to make the ID column fit as the report is crowded already.

I tried setting the ID column header and content to Display When: Screen Only, but that doesn't help, it still prints the second blank page.

How can I stop that second page printing? I don't want to just print page one as sometimes the report is more than one page of data.

In Excel you can set the print area. Is there a similar setting in Access? I can't find one.

Any ideas would be appreciated.

Peter

 

[CJ_London]

in your source query, simply sort by the ID field, but don't show it. If you are still going overwide, this suggests you have changed something else to cause it

 

[MarkK]

In design view your report has a background with draggable limits. On the right side, as you mouse-over the limit of the report background, the icon changes to indicate that you can drag the far right edge. Drag this edge left so the background narrows. Move or resize controls as required to make sure your report's background is narrower than the space between your margins.

Hope this helps,