By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,788 Members | 1,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,788 IT Pros & Developers. It's quick & easy.

Control Of What Is Printed In Page Footer

P: n/a
I have a report of about 50 pages. The report consists of two subreports, SRptA
and SRptB, in the Detail section of the main report (unbound) and each
subreport produces about half the pages. I would like to put an "A" in the page
footer of the main report when the data in SRptA is printing and a "B" in the
page footer of the main report when the data in SRptB is printing. Can someone
tell me how to do that.

Thanks!

Steve
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies

P: n/a
Without seeing the exact formatting of the report, I would try something
similar to this. In the OnFormat event of the detail section of each
subreport try setting the value of the textbox in the main report to A or B.

Me.Parent.txtNameOfTextbox = "A"

--
Wayne Morgan
Microsoft Access MVP
"Steve" <sp**@nospam.com> wrote in message
news:ek****************@newsread1.news.atl.earthli nk.net...
I have a report of about 50 pages. The report consists of two subreports, SRptA and SRptB, in the Detail section of the main report (unbound) and each
subreport produces about half the pages. I would like to put an "A" in the page footer of the main report when the data in SRptA is printing and a "B" in the page footer of the main report when the data in SRptB is printing. Can someone tell me how to do that.

Thanks!

Steve

Nov 12 '05 #2

P: n/a
Thanks, Wayne! That worked.

Steve
"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:I7******************@newssvr32.news.prodigy.c om...
Without seeing the exact formatting of the report, I would try something
similar to this. In the OnFormat event of the detail section of each
subreport try setting the value of the textbox in the main report to A or B.

Me.Parent.txtNameOfTextbox = "A"

--
Wayne Morgan
Microsoft Access MVP
"Steve" <sp**@nospam.com> wrote in message
news:ek****************@newsread1.news.atl.earthli nk.net...
I have a report of about 50 pages. The report consists of two subreports,

SRptA
and SRptB, in the Detail section of the main report (unbound) and each
subreport produces about half the pages. I would like to put an "A" in the

page
footer of the main report when the data in SRptA is printing and a "B" in

the
page footer of the main report when the data in SRptB is printing. Can

someone
tell me how to do that.

Thanks!

Steve


Nov 12 '05 #3

P: n/a
A friend, someone who unselfishly shares his knowledge and expects nothing in
return. Considers every question posted in this newsgroup very important to the
poster and is never critical or demeaning to the poster. Accepts every poster as
a human being and affords all posters the respect every human being deserves.

Steve
PC Datasheet
"Sam R" <sa********@NOSPAMspamfree.com> wrote in message
news:3F**********************@Gilgamesh-Frog.org...
What is an MVP?
In article <I7******************@newssvr32.news.prodigy.com >
"Wayne Morgan" <co***************************@hotmail.com> wrote:

Without seeing the exact formatting of the report, I would try something
similar to this. In the OnFormat event of the detail section of each
subreport try setting the value of the textbox in the main report to A or B.

Me.Parent.txtNameOfTextbox = "A"

--
Wayne Morgan
Microsoft Access MVP
"Steve" <sp**@nospam.com> wrote in message
news:ek****************@newsread1.news.atl.earthli nk.net...
I have a report of about 50 pages. The report consists of two subreports,

SRptA
and SRptB, in the Detail section of the main report (unbound) and each
subreport produces about half the pages. I would like to put an "A" in the

page
footer of the main report when the data in SRptA is printing and a "B" in

the
page footer of the main report when the data in SRptB is printing. Can

someone
tell me how to do that.

Thanks!

Steve









Nov 12 '05 #4

P: n/a
Thanks for the kind words Steve.

Sam, more information can be found at

http://mvp.support.microsoft.com/

--
Wayne Morgan
MS Access MVP
"Sam R" <sa********@NOSPAMspamfree.com> wrote in message
news:3F**********************@Gilgamesh-Frog.org...
What is an MVP?

Nov 12 '05 #5

P: n/a
Sam,

Take a look at Wayne's response to your post. It's not hard to pick an MVP out
of the crowd!!

Steve
PC Datasheet
"Sam R" <sa********@NOSPAMspamfree.com> wrote in message
news:3F**********************@Gilgamesh-Frog.org...
What is an MVP?
In article <I7******************@newssvr32.news.prodigy.com >
"Wayne Morgan" <co***************************@hotmail.com> wrote:

Without seeing the exact formatting of the report, I would try something
similar to this. In the OnFormat event of the detail section of each
subreport try setting the value of the textbox in the main report to A or B.

Me.Parent.txtNameOfTextbox = "A"

--
Wayne Morgan
Microsoft Access MVP
"Steve" <sp**@nospam.com> wrote in message
news:ek****************@newsread1.news.atl.earthli nk.net...
I have a report of about 50 pages. The report consists of two subreports,

SRptA
and SRptB, in the Detail section of the main report (unbound) and each
subreport produces about half the pages. I would like to put an "A" in the

page
footer of the main report when the data in SRptA is printing and a "B" in

the
page footer of the main report when the data in SRptB is printing. Can

someone
tell me how to do that.

Thanks!

Steve









Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.