hascontinued property

[Guest]

I can't seem to get this property to work. From what I understand, If you
use it within the group header section, when your group overflows onto the
next page of a report, acces triggers this property to true. I have a
"continued..." label I want to make visible when a group overflows and hides
when it doesn't but it won;t work and microsoft has a very generic
definition. Can any guru's out there please help?

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)


If GroupHeader0.HasContinued = True Then
Me.lblContinue.Visible = True
Else
Me.lblContinue.Visible = False
End If



End Sub

 

[Marshall Barton]

I can't seem to get this property to work. From what I understand, If you
use it within the group header section, when your group overflows onto the
next page of a report, acces triggers this property to true. I have a
"continued..." label I want to make visible when a group overflows and hides
when it doesn't but it won;t work and microsoft has a very generic
definition.

That's what most folks wish it would do, but noooo, it just
means that the one section (group header) has continued.

The old fashined way (back in A2 before there was such a
thing as HasContinued) is to use a counter text box (=1 with
RunningSum set to Over Group). Then a text box value
greater then 1 indicates that the group has spilled over
onto multiple pages.

In the typical situation the group header will have it's
ForceNewPage property set to Yes or the whole idea doesn't
mean a whole lot.

 

[Guest]

Hi Marshall. I added a text box to my group section, set it = 1, changed
RunningSum to Over Group, and put a watch on the textbox value but the value
keeps increamenting. What am I doing wrong? Do I have to reset the value
somewhere?

Thanks in advance.

 

[Marshall Barton]

The text box belongs in the detail section.

The Over Group setting will automatically reset it when the
group changes, but if you had it in the group header
section, it wouldn't reset until a higher level group
changed or the end of the report.

 

[Guest]

Marshall... it worked like a charm!

 

[Guest]

How do I create a counter text box?

 

[Marshall Barton]

How do I create a counter text box?

Set its ControlSource expression to =1 and its RunningSum
property to Over All or Over Group as needed.