Conditional Page Footer?

[Frank Situmorang]

Hello,

To update the data of the members per household/family, I have created a
report will be used as a letter to update the data of the members.l

As a page footer I have a closing sentence. But it could happen that the
family members are many, and can not accomodate in 1 page. How can I make a
page footer if more than 1 page, there is no page footer in this page and it
goes to the next page with the family member data, and page footer.

Thanks very much for any idea provided.

 

[Evi]

Lets call your control MyTxt.
So long as your report is grouped you can put this code into Header's On
Format Event, in between the Sub heading and the End Sub



Me.MyText.Visible = False


In the Group's Footer you can put

Me.MyText.Visible = True

This totally elegant solution from Bill Mitchell's blog
http://wvmitchell.blogspot.com/search?q=Group+Footer

Evi

 

[Frank Situmorang]

Thanks very much Evi, I will try to make it.

 

[Frank Situmorang]

Evi, it seems my problem is that in the page header, I have many controls.
Because in the page headher I have the household name and address ( many
controls of course) plus sentences to ask them to update their datas

While in the detail is the members of the house hold

In the page footer is a closing sentences to ask them to return the data on
such and such a date.

I appreciate anybody helps.

 

[Evi]

Why don't you put these controls in the Group header and footer, instead of
the page Header/Footer? Then you wouldn't need any code at all.
Evi

 

[John Spencer]

Another alternative is to add a report footer which will print immediately
after all the details.

This technique will only work for you IF you are printing only one household
at a time - which I assume is the case since you have the household
information in the Page header.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Frank Situmorang]

This is will be a mass printing John, since I want to send them to all
households to update their data periodically.

I appreciate your idea

 

[Frank Situmorang]

Thanks very much Evi, I just follow your instruction, it more simple, however
can we make the groping footer in the bottom of the page, because it is the
colosing sentences. I see now it allways shrink to the detal section

Thanks in advance