Force the group footer to print on the first page

  • Thread starter Thread starter VBNovice10
  • Start date Start date
V

VBNovice10

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.
 
Hello "VBNovice10".

VBNovice10 said:
Hello,

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

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)
 
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.
 
Hello.


VBNovice10 said:
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.
Click to expand...

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?
 
My report is based off of a current form we manually create through Microsoft
Word for every customer. Each customer may have anywhere from 1 to >300
items, so the detail section length varies. But I want to populate the
report through Access from my database to expedite the former form creation.

My report has a report header with a logo, a page header with recurring data
on each page, a detail section with rows of data populated by rows in my
database, a group footer, a page footer with page numbers, and a report
footer which takes up the entire last page.

I was hoping there was a code/method to force the group footer to always
print on the "first page" only regardless of the number of rows in the detail
section. The main question is can a group footer be forced to print in the
middle of a group section?

Thank you for your help. Please let me know if you need more detail.
 
Thank you for your quick response. As far as faking it, here are some
details of my report. My current group footer contains 4 signature blocks
tracking items exchanged from one person to another person. There are five
columns (Item#, Date, Released By, Received By, and Purpose, respectively).
The 4 rows track four different exchanges between individuals. The
information in this section is provided post printing and the framework is
needed only on the bottom of the first page. There is no computing or
calculations required to be filled into this section prior to printing.

Please let me know if you need further information or if my description is
unclear.

Thank you.
 
Back
Top