[AccessD] Continuing Group on Report Print out

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