section width is greater than page width

[Carol E]

I set up a report (Access 2002) but it generates every other blank page. An
error message states section width is greater than page width. I want to
eliminate the blank pages. All my data is displayed, none are hidden. How
do I fix this? It is driving me nuts!

 

[Duane Hookom]

Grab and drag the right edge of your report to the left while in design
view.

 

[Brian]

Hey, Duane. Not to complicate matters, but I have this problem every time I
distribute my app to certain users. In dev, I use default printer & set all
my L/R margins to 0.5", but appears that their default printer must have a
minimum greater than 0.5", because they get this message. If I have them go
to Page Setup & change everything to 0, each margin changes to what appears
to be the minimum (for the default printer?), including .666 for the right
margin in one case. Is my assessment correct concerning the reason correct,
and if so, is the solution just to make sure I allow exceptionally large
margins to accomodate any such variations?

 

[Duane Hookom]

Apparently many of your reports are landscape. Most inkjet type printers
can't print within 1/2 inch or so from the bottom of a page. The bottom
become the right when printing landscape. The best solution is to make sure
your report allows for the largest margins of your users.

Left, right, and top margins can almost always be set smaller than the
bottom margin.

 

[Brian]

Actually, I don't have the problem with any of the landscape reports, and
these are all LaserJet 2000 & 4000-series laser printers.

There is an additional quirk that may be related and shed some light. On one
particular report, each time I distribute the .mdb front end, the first time
it is opened on a particular PC (or terminal server, in one case), then
entire report is either very tiny (i.e. the entire report fits into the upper
left 1/4 page even with Zoom set to Fit, and it prints that way) or very
large (the report appears to be in perhaps 72 font, even when zoomed to Fit,
and it prints that way, spanning multiple pages). If the user changes to
landscape, then back to portrait, the problem is resolved permanently (or at
least until they get a new front end from me). It can also be resolved by the
client switching to a specific printer, then back to the default.

 

[Duane Hookom]

This sounds like you might need to install new printer drivers. I am not
aware of issues running through Terminal Server.

 

[Brian]

The same thing happens for a standalone (brand new PC, XP Pro, Access 2003
runtime) client (same application, but different customer). He has, I
believe, a LaserJet 2200, and just like clockwork, each time I send a new
front end, all the reports open & print across multiple pages until he
landscapes & re-portraits them in page setup... It happened on his prior PC
as well (Win2k, Access 2002 runtime).

I was hoping that my upgrade to Access 2003 on my development system
(actually, a clean install of Windows, Office 2003 Pro, & VS Tools for
Office) might alleviate the problem, but it did not, and I have posted the
issue several times, but with no responses.