Error message with my report

S

Sharon

Hello again
I have created a report and when i try to run it i keep getting the office
assistant telling me that the section width is greater than the page width -
No items in the additional space, some pages may be blank. I have ajusted
the page set up for the margins but this seems to have no effect i have even
reduced the size of everything and it still has no effect. the page looks
fine to me with everything on show and space to spare.

Can anyone tell me why i am getting this message and how to get rid of it.

Regards
Sharon
 
J

Jerry Whittle

It could be something as simple as a thin little line just a tiny bit into
the next page. Go to design view and try to find any lines that are too long.
You may have to move the various headers and footers to see it.

Next go to the print setup and make the margins smaller.
 
J

John Spencer

Probably you have a large grey area on the right side of the report with
nothing in it.
Grab the right edge of the report and drag it to the left.

Alternative click on the report so you have the report selected and not any
section or control
(Click on the tiny square on the top left of the report)
In the properties of the report type 0 for the width property and exit the
property, the property will reset to the minimum width containing all the
controls.
Save your report. You should no longer get the error message.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
S

Shazza

John you are a genius. It worked and it was so simple wish i had thought of
that hours ago. thank you very much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top