Hide Footer

[leonardwalker]

I would like to hide the section footer on certain conditions. I have tried to use several methods but normally I get an error stating that Access can't find the object I am referring to.

I tried adding code in the on print or on format section of the footer property the report such as:

me!groupfooter1.visible=false

Couldn't find groupfooter1 was the response.

How do I refer to the group footer if I am using this kind of code and can you use the visible method to hide the entire footer?

 

[Jack Cowley]

Reports are not my long suit by any stretch but I believe that you will have to hide the individual controls.... Do NOT take this to the bank....

hth,
Jack

 

[R. Hicks]

You need to find the "Section Index Number: and use this example:

Me.Section(3).Visible = False

Change the index number to the correct section index number.

HTH
RDH

 

[Jack Cowley]

LMAO! Thanks Ricky! What would I do without you?

Jack

 

[R. Hicks]

LOL ... Jack I guess I was just "Johnny on the spot" ...

RDH