Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Static Group Footer Location (ACCESS 2002)

    Hi Everyone,
    I have an invoice report that basically is grouped by invoice number. All the invoice header data is within the group header. I have a detail section and an invoice group footer with totals. My question is that I always want the invoice totals to print in the same location of the page. The users will be using a pre-printed form. Right now it prints directly after the last detail.
    When I used the page total section it actually printed too far down the page. How can you specify exact locations to print?
    Any help greatly appreciated....
    Steve.....

  2. #2
    Lounger
    Join Date
    May 2002
    Location
    Fort Worth, Texas, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Static Group Footer Location (ACCESS 2002)

    When you say page total do you mean page footer? If not click View|Page Header/Footer, in design mode. The grouping bar will be above the Report Footer but will print below it on each page. To move a field higher on the page make the blank space below in larger. It will give you less detail area.

    Hope this helps.

  3. #3
    New Lounger
    Join Date
    Jan 2003
    Location
    USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Static Group Footer Location (ACCESS 2002)

    I'm sorry...Yes, I meant page footer. I've put more white space in and it did move the field where I wanted it. Thank you. However, it now prints every page instead of only on invoice number break. Is there a way to just print the page footer when a group break occurs?

  4. #4
    Lounger
    Join Date
    May 2002
    Location
    Fort Worth, Texas, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Static Group Footer Location (ACCESS 2002)

    That was a tricky one. Try this:

    Leave the field in the page footer and set the visible property to false. In the Page Footer OnFormat event, enter this code where Text1 is the name of your field. The intelisense does not work, you will have to type in the '.visible'

    If Me.Page = Me.Pages Then
    Text1.Visible = True
    End If

    Page is the current page number and Pages is the total. When they are equal you are on the last one.

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

    Re: Static Group Footer Location (ACCESS 2002)

    You will need a little bit of code for this.

    1. Set the text box with the invoice total to visible in the On Print event of the group header:

    Private Sub GroupHeader_Print(Cancel As Integer, PrintCount As Integer)
    txtInvoiceTotal.Visible = True
    End Sub

    2. Hide the text box when moving to the next page.

    Private Sub Report_Page()
    txtInvoiceTotal.Visible = False
    End Sub

    Replace GroupHeader by the name of your group header, and txtInvoiceTotal by the name of the text box displaying invoice totals.

Posting Permissions

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