report footer print only on page 1. Is it possible?

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I am required to use a standard form which requires the total on the front
sheet. Is there a way to print the total only on page one?

Any help would be greatly appreciated.
 
Denise,
Use the Format event of the report section where your total displays.
In this example, a control, named sumLength, which usually displays many
times over the length of the report...is only displayed on Page 1

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
sumLength.Visible = [Page] < 2
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Denise,

Thinking out loud...

Put a field txtPage with a control source of Page, make it invisible. Then
put: =IIf([txtPage]=1,[WhateverYourTotalFieldNameId],Null) in the control
source of another text field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
Back
Top