Results 1 to 13 of 13
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    Group header not printing on all pages

    How do I get the Group Header to print on subsequent pages. The GH prints the first time just fine, but if the group continues to a second page it doesn't print. I have set theoption to keep the group together one one page. I have a grouping above the one I want to print, but am not using it on the report.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,526
    Grp header only shows at the start of the GROUP. For all pages, put it in the PAGE header.

  3. #3
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    A grp hdr printing on every page as a page hdr does little to identify the group, unless there is only one group, that shows up in the middle of a page. I tried what was suggested and got the same header on every page regardless of the group that was on the page.

  4. #4
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I am still looking for help with this one. Anyone please.

  5. #5
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Haven't tried this - make Page header and Group header the same, set a First Time Switch, make Group Header invisible on First Time?

  6. #6
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    Sounds good, but how do I do this. My knowledge for this is very limited.

  7. #7
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    unless you have a prohibition against it a very easy solution is to insert a page break after each group, then you can put the information in the page header and you will be fine.

  8. #8
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I would much prefer the data to print continuously, and that is what the user wants. But, I'll keep this in mind as an alternative, if I can sell it to the user.

  9. #9
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I have to admit that this isn't as easy as I thought it would be. In the OnFormat even for the group header and the page header (tried both) doesn't seem to make the text box visible/invisible.

    I don't understand Microsoft's comment - is it overwriting the VBA code with the textbox's properties?:
    OnFormat: "After the control is displayed or hidden, Microsoft Access formats the section by using the values of format properties, such as CanGrow, CanShrink, HideDuplicates, KeepTogether, and Visible."


  10. #10
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442

  11. #11
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    or maybe this: (I haven't tried either)
    http://bytes.com/topic/access/answer...detail-records

  12. #12
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Oh gosh! Your second link - set repeat to yes - works perfectly. So simple!

  13. #13
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    Perfect solution! Thanks.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-06-2014, 10:58 AM
  2. Replies: 9
    Last Post: 04-21-2013, 05:37 PM
  3. Replies: 0
    Last Post: 02-25-2013, 04:43 PM
  4. Replies: 3
    Last Post: 04-17-2012, 10:59 AM
  5. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 08:53 AM

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