Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Header (Access 2003)

    I have a report that has Group Header Repeat Section set to "Yes"; in addition a Group Footer that just displays a line to break up the each section. My issue is that I don't want the Group Header to repeat; unless there is a record to print. I have Group Headers repeating just to print the Group Footer; I know that's what the Group Header Repeat Section is set to do; I'm just wondering if I can set the Group Header Repeat Section to print/display if there is a record; otherwise don't repeat the Group Header just because the Group Footer did not fit on the previous page.

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

    Re: Report Header (Access 2003)

    Although not quite what you asked, the simplest solution is not to use a group footer at all, but to shift down the controls in the group header a bit and to insert a line above them.

    Otherwise, you'd have to write non-trivial VBA code.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Header (Access 2003)

    Thanks for your response; but I tried that and that means every Group Header on the top of the page has a line and extra space; I don't mind writing non-trivial VBA code.

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

    Re: Report Header (Access 2003)

    > I don't mind writing non-trivial VBA code

    Good luck, I tried it but failed. If I do find a solution, I'll post it.

Posting Permissions

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