How can I make a group not to show/display in a report if no data is under that group?

erick-flores wrote:

Add a text box to the Valve group header.
I add a text box to the fields under the Valve group header name:
gskCount. But not in the "group header"
When you say "Add a text box to the Valve group header" that for me is
create/add a text box inside the group header, where right now the
field is gsk_id. So I dont see how I can add a text box to the group
header. So I add it under the fields under my group header.

It did work when there is data under that group. I can see the textbox
counting the data. But when there is no data an error will occur.

"Run-time error '2427':
You entered an expression that has no value."
And it will highlight the "Cancel = (Me.gskCount = 0)"

My code behind the OnFormat is:
Private Sub GroupHeader6_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = (Me.gskCount = 0)
End Sub

I am doing something wrong?


It sounds like you did not put the gskCount text box in the
group header that you want to count (GroupHeader6 ?).
Adding the text box to the header section is the same as
addin one to any other section. I don't understand why you
are having trouble doing it.

--
Marsh
MVP [MS Access]