Results 1 to 3 of 3

Thread: Footer Question

  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Footer Question

    I have a report that contains a footer. The footer contains bound controls. If the user does not add information in the form for the controls then I do not want the footer to print. It the user adds, then print all the information. How can I tell access to not print the footer if the data does not exist?

    Thanks,
    Deborah

  2. #2
    Star Lounger
    Join Date
    Dec 2000
    Location
    Hellertown, Pennsylvania, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer Question

    Would a simple OnFormat event for your Footer Section work?

    If IsNull(ControlName) Then Me.PageFooterSection.Visible = False

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer Question

    Thanks!

    I have already figured it out but at the moment was experiencing a case of being brain dead!!!!

    Deborah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •