Hide Footer

G

Guest

Hello,

I have a form with a footer that currently displays for each record. How
can I hide the footer after the the user leaves the first record. I was
thinking I could do something with record count and hide the controls or
change the visible property.

Just beginning to learn!

Thanks for your time,
John
 
A

Allen Browne

Assuming the focus is not in the form footer, you could use the AfterInsert
event of the form to hide the section:

With Me.Sections(acFooter)
If .Visible Then
.Visible = False
End If
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form footer visible only when values match 3
Delay in getting subform total to calculate 2
Error on simple expression in footer 2
Hide form footer 4
Totals in SubForm Footer do not display corectly on Main Contiuous form 3
How can I know recordset count changed 1
Can I hide duplicate values in an Access Form? 3
How to force a form footer to be very short (Access 2003) 3

Top