report width

[Pam Ammond]

The Access 2002 report width refuses to be smaller than
20.9167". I tried dragging the report right edge and
changing the Report - Width property. They change back
to 20.9167".

I preview the report and it is 2 portrait size pages with
the second page completely blank.

I choose Design View - Select All to see if there is
anything off to the right and their is nothing beyond
6.49" that I can see.

I changed Page Setup to margins of .5 inches and column
width of 7.5".

I changed Report - Autoresize to No.

I turned the Report Header, Report Footer, Page Footer,
and Page Header to Visible - No. (there is nothing on
them anyway). There are 2 other headers which are
visible.

I saved, exited, and reopened the report.

What else do I need to do to make this report only 1 page
in width, not 2?

What can I do to make the report width less than
20.9167"?

 

[Duane Hookom]

Nice code Allen, however there may be a very narrow control out to the
right. You could change one line
If ctl.Left + ctl.Width > 6.5 * 1440 Then
I'm not sure if there are any controls that don't have both properties such
as a pagebreak control. If so, this might error so an "On Error Resume Next"
wouldn't hurt.

 

[Allen Browne]

Yes, spot on, Duane.