Multipage Header in Reports

[reportguy]

I am creating an automated proposal system using MS Access 2003. My
Proposals have at minimum 6 pages.

Page 1 has the cover letter
Page 2-5 has static product information never changes and is only
printed once in the report
Page 6-? have the actual data items and pricing the customer is looking
for.

My question is how can I make a multipage report that can print out the
way I need it to print as stated above? I have tried page breaks in
the headers but I seem to be running out of space in the header. I
know in Crystal Reports I can add multiple headers and put a new page
after each header. I would like to do it in Access as well.

Any help would be welcome.

 

[Marshall Barton]

I am creating an automated proposal system using MS Access 2003. My
Proposals have at minimum 6 pages.

Page 1 has the cover letter
Page 2-5 has static product information never changes and is only
printed once in the report
Page 6-? have the actual data items and pricing the customer is looking
for.

My question is how can I make a multipage report that can print out the
way I need it to print as stated above? I have tried page breaks in
the headers but I seem to be running out of space in the header. I
know in Crystal Reports I can add multiple headers and put a new page
after each header. I would like to do it in Access as well.

Well, you can create some additional headers in Access too,
but I think it would be much easier to create a little table
to park your cover letter text and the boiler plate.

Then you can use two short CanGrow text boxes in the report
header section with a page break control between them. The
text box's would then just use a simple DLookup expression
to retrieeve the text.

Not only does that make the report easy to design, but when
it comes time to change the text, you will not have to go
back and change the report.