Sorry if this is a really basis question but I'm having a problem with the pysical size of a report I'm creating.

I'm creating a report that spreads to 12 pages per query lookup. However I'm finding the maximum size I can set the report to is 54cm wide and 54cm high which only allows me to have 9 A4 pages. Is there ny way to overcome this without making this 2 separate reports.

Thanks,

Terry

This sounds like a monster that should never seen the light of day!

Do you really need to have a report that is this big? How do you read a report that is twelve pages wide? Are you going to sellotape the pages together?

It's not clear why or what you want. Can you explain?

Basically, I am carrying out audits on a number of contracts.
In the past each audit has been typed up on a MS Word document which has left me with numerous files. I was hoping to collate all of this information into one database and be able to do a lookup per contract.

However, the standard template my company uses is 12 pages and it is this template I need to duplicate in a report.

I think I can do it by allowing the text box property on the report to grow or shrink and by using page breaks, but some areas are surrounded by rectangle borders which I cannot seem to set to grow or shrink so they remain a fixed size.

Thanks

Ah, right.

The way I would tackle this is to create a template in Word, hold the data in Access and use a merge routine to create the completed report. All this can be automated from with Access.

Word is much better at dealing with documents than Access.

If you don't fancy this, you could create a series of reports within Access, say one for each page of your report, and run these in sequence from the same query. As an Access newbie, this could be run from a macro that would be easy to set up.

The Word option is better, though.

Neil,

thanks for your help.
I'll have a play and give both methods a try.

Thanks again.

Terry