Prev: A Great Big Thank You!
Next: Use combo to print report between two sets of dates
From: VBNovice10 on 27 May 2010 16:55
Hello,

Does anyone know how to force the group footer to print only on the first
page of an Access 2007 Report?

Thank you in advance.
From: Wolfgang Kais on 28 May 2010 03:42
Hello "VBNovice10".

"VBNovice10" wrote:
> Hello,
>
> Does anyone know how to force the group footer to print only on the first
> page of an Access 2007 Report?

You could try to change the visibility of the group footer section in it's
format event, using a line like this:

Me.NameOfTheGroupFooterSection.Visible = (Me.Page = 1)

--
Regards,
Wolfgang


From: VBNovice10 on 2 Jun 2010 10:01
Thank you for your help, but the code didn't work. The group footer still
did not appear on the first page. I may have to reconsider my report design.

Thank you again.

"Wolfgang Kais" wrote:

> Hello "VBNovice10".
>
> "VBNovice10" wrote:
> > Hello,
> >
> > Does anyone know how to force the group footer to print only on the first
> > page of an Access 2007 Report?
>
> You could try to change the visibility of the group footer section in it's
> format event, using a line like this:
>
> Me.NameOfTheGroupFooterSection.Visible = (Me.Page = 1)
>
> --
> Regards,
> Wolfgang
>
>
> .
>
From: Marshall Barton on 2 Jun 2010 14:12
"the code didn't work" does not convey much information
beyond the fact that you did not like the result.

AFAICS, Wolfgang's code does what you asked for, so I am
guessing that there may be a flaw in your question or
terminology. Note that group footers only print at the end
of the group and do not have much at all to do with where a
page boundary happens to be. Maybe you really meant to say
page footer??
--
Marsh
MVP [MS Access]


VBNovice10 wrote:
>Thank you for your help, but the code didn't work. The group footer still
>did not appear on the first page. I may have to reconsider my report design.
>
>"Wolfgang Kais" wrote:
>> "VBNovice10" wrote:
>> > Does anyone know how to force the group footer to print only on the first
>> > page of an Access 2007 Report?
>>
>> You could try to change the visibility of the group footer section in it's
>> format event, using a line like this:
>>
>> Me.NameOfTheGroupFooterSection.Visible = (Me.Page = 1)

From: Wolfgang Kais on 3 Jun 2010 03:20
Hello.

"VBNovice10" wrote:
>>> Does anyone know how to force the group footer to print only on the
>>> first page of an Access 2007 Report?

Wolfgang Kais wrote:
>> You could try to change the visibility of the group footer section
>> in it's format event, using a line like this:
>>
>> Me.NameOfTheGroupFooterSection.Visible = (Me.Page = 1)

"VBNovice10" wrote:
> Thank you for your help, but the code didn't work. The group footer
> still did not appear on the first page. I may have to reconsider my
> report design.

As Marshall Barton said, make sure that the section you associate the
code with is indeed the section you want to hide/display, and that the
name of the section used in code is correct. Always keep in mind that
a group footer will be displayd below the last detail record of
the group (on the same page, provided that there is enough space).
You could also verify the ForceNewPage property of the group footer.
Did you accidently set this property to "before section"?
You said "the group footer still did not appear on the first page".
Still? I thought that is WAS displayed and you wanted it to be displayed
ONLY on the first page? What is the page number of the desired page?

--
Regards,
Wolfgang


 |  Next  |  Last
Pages: 1 2
Prev: A Great Big Thank You!
Next: Use combo to print report between two sets of dates