hascontinued property

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Matt said:
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.
Click to expand...


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.
 
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.
 
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.
 
Odniel said:
How do I create a counter text box?
Click to expand...


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