David McAfee
davidmcafee at gmail.com
Tue Sep 30 15:03:35 CDT 2008
Thanks for the quick response Lambert. I've tried using the .RepeatSection as well as just showing the label and it seems to be skipping the whole group. Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If Me.GroupHeader0.HasContinued Then Me.lblContinue.Visible = True Me.Section("GroupHeader0").RepeatSection = True 'Reports("rptRGAPrintOut").Section("GroupHeader0").RepeatSection = True End If End Sub 'have also tried just printing the name, in case I was wrong about the name of the group header. It seems to repeat six times if I put a optional stop in there. Debug.Print Me.GroupHeader0.Name GroupHeader0 GroupHeader0 GroupHeader0 GroupHeader0 GroupHeader0 GroupHeader0 Debug.Print Me.GroupHeader0.RepeatSection False False False False False False Any idea what I am doing wrong? On Tue, Sep 30, 2008 at 12:02 PM, Heenan, Lambert <Lambert.Heenan at aig.com>wrote: > Check out the HasContinued property of report sections. If you reference > it > in the OnFormat event of your group header you can determine if you need to > output "(continued)" > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee > Sent: Tuesday, September 30, 2008 2:23 PM > To: Access Developers discussion and problem solving > Subject: [AccessD] Continuing Group on Report Print out > > Brain Fart... > > Is it possible to display a label and/or Group text box on a report that > has > had its group broken up on multiple pages? > > I have a report that has a huge list of parts. The list is grouped on a > field "BillTypeID". > > In that group's header, I display the Bill Type (Billable, Non-Billable, > Upgrade...) > > I'd like to be able to print out something like "Non-Billable (continued)" > on the top of the next page that has had its group broken up. Is this > possible? > > Thanks, > David > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >