Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    page Header (k2)

    How can I repeat page header or group header on a report, only if page number is odd(1,3,5)
    I used this code but when I run the report it hangs forever

    Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
    'If Me!Text301 Mod 2 = 0 Then
    'GroupHeader1.Visible = False
    ' End If
    end sub

    new user

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page Header (k2)

    You could better set the visible property of your controls to false and modify the height if the group header.
    The height is set in twips. 1 twip = 1 inch / 1440
    <pre>Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    If Page Mod 2 = 0 Then
    Me.txtKNAME.Visible = False
    Me.GroupHeader0.Height = 0
    Else
    Me.txtKNAME.Visible = True
    Me.GroupHeader0.Height = 1134
    End If
    End Sub</pre>

    Francois

  3. #3
    New Lounger
    Join Date
    May 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page Header (k2)

    Thanks much

Posting Permissions

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