View Single Post
  #5  
Old June 3rd, 2010, 08:20 AM posted to microsoft.public.access.reports
Wolfgang Kais[_4_]
external usenet poster
 
Posts: 18
Default Force the group footer to print on the first page

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