3 page Limit???

[apryor]

Hi,
Due to the amount of information I need to squeeze into this report, I'm trying to create a 3 page report. The problem I have is that while in design view, the bottom portion of the page will only stretch to 22 inches. Is this the max limit? In print view, I can see a full length 3rd page but only 25% has my info on it. Any help is greatly appreciated.

 

[KenHigg]

Have you tried using page breaks?

 

[apryor]

I added page breaks, but due to the amount of info I need on this report(literally full pages of text) it doesn't seem to help. I need a way to increase the available real-estate.

 

[KenHigg]

How long is the paper you're printing to?

 

[apryor]

8 1/2 x 11

 

[KenHigg]

Sorry, I'm probably being dim here - Why do you need a 22"+ page footer?

 

[apryor]

Could be that I'm the one that's dim, if I'm going about this process wrong.

Here's what I'm trying to accomplish. I have a form in Access that users enter various info into. Upon clicking a button, that info is passed to a report. The report in question is a mirror image of a three page MS Word doc that my users have saved as a template and currently manually fill out. So what I have is a three page Word doc, that I'm trying to duplicate using a report.

 

[KenHigg]

So on the bottom of the word doc, say you have a place where the user puts info 'x'. In the Access report, you can't squeze all the stuff down to that point on the first page in the report then put in a page break to start the second page? Have you tried making the report margins wider?

 

[apryor]

I tried em all, and it didn't help.

 

[KenHigg]

Can you post a print screen of your word doc and of your report so I can get a better understanding of the problem. Sounds like you need to make your font smaller on the report. ?


Edit, I need to bug out - Catch you later?

 

[Pat Hartman]

If you need more than 22" to hold all your fields, it is more than likely that you have a table design issue. You probably have what we call a repeating group that should be stored in a separate table. So, if the data were properly stored in a 1-many relationship, the detail section of the report would be only a couple of inches and it would repeat for each many-side record. The ultimate report would still end up at three pages but the actual size of the detail section would be siginificantly smaller.