Heenan, Lambert
Lambert.Heenan at AIG.com
Tue Sep 30 15:13:55 CDT 2008
Well you say... "In that group's header, I display the Bill Type (Billable, Non-Billable, Upgrade...) " So I would just have another textbox (say named "txtContinued") right next to the bill type textbox with a data source of ="(Continued)" and then in the header Format event you would say txtContinued.Visible = GroupHeader0.HasContinued Replacing "GroupHeader0" with the correct name of the group header. 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 4:04 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Continuing Group on Report Print out 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com