report/subreport trailing text

[Guest]

I have a report/subreport defined that electronically fills in a paper form
for printing. At the bottom of the hardcopy form is some text that identifies
the form, and I've duplicated this in my report.

My question is this: How can I ensure this text prints on every page? I want
this text to print at the bottom of the subreport, and for subreports that
fit entirely on one page, this happens. However, if the subreport spans a
page break, I want this text to print on each page, and it only prints at the
bottom of the subreport.

Thanks for any suggestions.

 

[Joe]

John,

Make the textbox in your sub-report hidden (Visible=False). Then
use a calculated control (TextBox) in the main report's Page
Footer and set its Control Source to:
"=Reports![MainReport]![SubReport].Report![SubReportControlName].

HTH,

Joe



"John B. Smotherman" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

Joe-

Thanks for your reponse. I'm sure I failed to make clear that I don't want
the text to print at the bottom of the page if the subreport only fills half
the page. The text box should print immediately below the subreport, and it
does if the subreport doesn't completely fill the page.

Perhaps my question could best be put this way: "How can I print a page
footer ONLY if the report spans multiple pages, and NEVER print it on the
final page?"

Thanks again for your response. Do you have a suggestion for my revised
question?

John,

Make the textbox in your sub-report hidden (Visible=False). Then
use a calculated control (TextBox) in the main report's Page
Footer and set its Control Source to:
"=Reports![MainReport]![SubReport].Report![SubReportControlName].

HTH,

Joe



"John B. Smotherman" <[email protected]>
wrote in message

I have a report/subreport defined that electronically fills in a
paper form
for printing. At the bottom of the hardcopy form is some text
that identifies
the form, and I've duplicated this in my report.

My question is this: How can I ensure this text prints on every
page? I want
this text to print at the bottom of the subreport, and for
subreports that
fit entirely on one page, this happens. However, if the
subreport spans a
page break, I want this text to print on each page, and it only
prints at the
bottom of the subreport.

Thanks for any suggestions.