Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Turn Off Header when Footer ON (Access2000-03)

    Hi!
    I am displaying Summary in Group Footer.
    I want to turn off Page Heather when HF is displayed.

    I am trying
    If GroupFooter0. = True Then
    txtCoName.Visible = False And txtBU.Visible = False And txtNameD.Visible = False
    End If

    No luck. Please, advice.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Where did you put this code?

    Something has gone wrong with

    If GroupFooter0. = True Then

    What was after the period?

    The line

    txtCoName.Visible = False And txtBU.Visible = False And txtNameD.Visible = False

    makes no sense, it should be three lines:

    txtCoName.Visible = False
    txtBU.Visible = False
    txtNameD.Visible = False

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Sorry it is better now except it is gone from everywhere because I need to have it on correct event which isnt Report_Open but which one?

    Private Sub Report_Open(Cancel As Integer)
    If GroupFooter0.Visible = True Then
    txtCoName.Visible = False
    txtBU.Visible = False
    txtNameD.Visible = False
    End If
    End Sub

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Which section of the report contains txCoName etc.?

  5. #5
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Thanks Done!

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Oh. How?

  7. #7
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Hi!
    I had another Header and I had moved all 'troubled' txts there and it works! Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Turn Off Header when Footer ON (Access2000-03)

    Yep, that's the solution.

Posting Permissions

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