Discussion Locked

Access 2000 Reports

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to be able to create reports that are about ten pages long. How can I get round the problem of page setup, column length, not allowing me to exceed 54cm whilst in design view? In preview I can see many pages but am unable to drag the detail section any further than 54cm, giving me a headache.

3 replies

by bill_h

The unfortunate answer is...you can't.

Access limits the *height* of sections (Page Header, Detail, Page Footer, etc.) to a maximum of 22 inches, or 55.87 cm. The *Width* of reports has the same limit.

Although there is no way to exceed the limit, you can avoid the pain of having to repeatedly scroll the window and drag the section. Click on the Detail section, and open up the Properties window. Under the "Format" tab is the Height property (it's under the "All" tab as well, but easierto find in "Format"). Enter the heighth desired; if you enter a number exceeding the maximum, an error message will be displayed.

I guess I can't say "Hope this helps...", because it obviously doesn't...

This discussion is closed to new replies.