[AccessD] Hide Page Header on Report Footer

Larry,

  So your report footer doesn't always start on the last page...hum

  Ok here's what you do:

1. Place a hidden text box on the report and reference the .pages property.
If you're already doing that some place else, then don't do this step.

2. In the report footer OnFormat event, save the current page number to a
variable or a table.

3. In the Page Header OnFormat

  If <saved page #> >= Me.page then
	Me.Section(3).Visible = False
  End If

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lawrence
Mrazek
Sent: Thursday, February 02, 2006 1:33 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Hide Page Header on Report Footer


Hi:

I'm trying to hide the Page Header section of a report on the Report Footer
section. I thought I had a solution, but it won't work when the Report
Footer > 1 page long.

Basically, I added this to the the OnFormat property of the Page Header:
If page=pages then
	Me.Section(3).Visible = False
End If

Any hints would be much appreciated.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com