Hide Footer

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top