Results 1 to 4 of 4
  1. #1
    lazarus is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    2

    Detail Section of 2nd Page is Cut in Half - All other pages are fine

    Hello,
    I have a 14 page report in which I want the footer to appear only on the first page. I accomplish this with some code in the OnFormat event of the page footer:
    If Page > 1 Then
    Me.PageFooter2.Visible = False
    Else
    Me.PageFooter2.Visible = True
    End If


    The first page has the footer (great).
    The 3rd thru the 14th page does not (great).
    The 2nd page also doesn't have the footer - but - it only shows a half page of data! The data continues where it left off on the third page!
    So, to sum up:
    1st Page: Footer with detail section containing 16 rows of data.
    3rd thru 14th Page: No footer section with 28 rows of data.
    2nd Page: No footer with only 16 rows of data.

    Does anyone know why this is happenning?

    Thanks,
    L

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    1st...you can reduce to a single line: Me.PageFooter2.Visible = PAGE = 1

    2nd:
    are you sure there are :
    no pagebreaks on the form
    A grouping footer?
    GROUPING KEEP TOGEHER?
    width of the rpt wider that it should?

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe it has to do with the "Keep Together" and or "Force New Page" properties for the Footer and or Detail section.

  4. #4
    lazarus is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    2
    Quote Originally Posted by ItsMe View Post
    Maybe it has to do with the "Keep Together" and or "Force New Page" properties for the Footer and or Detail section.
    Thanks to all for your help.
    I put my original code behind the OnFormat event of the page header instead of the page footer and it worked.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-09-2014, 07:24 PM
  2. height of Detail section in reports
    By Nicola in forum Reports
    Replies: 4
    Last Post: 05-31-2013, 02:46 AM
  3. for each record in detail section
    By nkuebelbeck in forum Reports
    Replies: 3
    Last Post: 05-28-2013, 01:42 PM
  4. Replies: 1
    Last Post: 05-25-2013, 11:19 AM
  5. Replies: 6
    Last Post: 03-26-2013, 12:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums