Results 1 to 12 of 12
  1. #1
    DougLowry
    Guest

    'Continued from previous page' in report header

    Hello:
    I am building a multi-page report that contains several group headers. When the group header breaks across several pages I want to make a label visible which reads,

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Continued from previous page' in report header

    Put your label in the group header or page header, not in the detail and see if that makes a difference. The detail is the wrong place for it anyway.
    Charlotte

  3. #3
    DougLowry
    Guest

    Re: 'Continued from previous page' in report header

    Hi:
    Thanks for the suggestion. I

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Continued from previous page' in report header

    Sorry, I didn't read your post correctly. I've never been able to get WillContinue to work at all, and I've seen dozens of posts on the subject to the same effect. However, HasContinued can be made to work, so take a look at it instead.
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 'Continued from previous page' in report header

    Try dropping the Me!, it doesn't seem to work well in reports.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    DougLowry
    Guest

    Re: 'Continued from previous page' in report header

    Thank you for the advice.

    I tried putting the sample code in a Private Sub called from an Event Procedure in the Detail

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 'Continued from previous page' in report header

    I don't think Me.Detail will work. You need to use Me.Section(0).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    DougLowry
    Guest

    Re: 'Continued from previous page' in report header

    Well, I tried it both ways. Using Section(0) and Detail, but neither way work.
    I've tried WillContinue and HasContinued same results either way.
    What else can I try?
    Thanks,
    Doug

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 'Continued from previous page' in report header

    I have found the WillContinue and HasContinued properties to be a bit of a pain. They are really only useful if you have a report in which the detail section is quite long, and it might continue on another page. Don't confuse this with the typical situation in most reports in which you have a detail section that is only 1 line high. So, if your report recordset is 80 records, you will print the detail section 80 times. But the WillContinue/HasContinued will only kick-in if any particular detail prints on 2 pages. If 1 detail line finishes exactly at the bottom of the page, the next detail will start at the top of the next page, so no WillContinue/HasContinued flags will be set! I found it easier to use the pageno property. If I'm on page 2, then I know the report was continued!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  10. #10
    DougLowry
    Guest

    Re: 'Continued from previous page' in report header

    Yes, I was just reading Access 97 Developers Handbook by Liwin, Getz, and Gilbert. This is an excellent source of information. The authors lament the fact that WillContinue and HasContinued shows great promise but never lives up to their claim. They say in the book that the only reason they include this topic is for completeness. The properties don

  11. #11
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 'Continued from previous page' in report header

    If your only intention is merely to detect that you are on some other page other than Page 1, then you can use the Me.PageNo property. For example, create a label (lblContinued) in Page Header and set its caption to "Continued from prior page". Your code to make it appear on pages 2+ would be:
    lblContinued.visible = (Me.PageNo > 1)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  12. #12
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Continued from previous page' in report header

    No, it doesn't not in the detail section's events at all. It belongs in either a page header or a group header. You don't want a label printing between every record in the detail. You want it to print once on the page if it applies. That means you put it in a header that will print no more than once on a page.

    Oh, and I would recommend you use the OnFormat rather than the OnPrint event. You won't ever see the results of the OnPrint event except in what comes out of the printer. If you use OnFormat, it will show up in the preview and in the printed document.
    Charlotte

Posting Permissions

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