Group Footer

[BOONER]

How can I make a group footer only visible if the detail section contains
more than one record. I don't want to see my totals at the bottom of each
group if the group only contains one record.

 

[Marshall Barton]

How can I make a group footer only visible if the detail section contains
more than one record. I don't want to see my totals at the bottom of each
group if the group only contains one record.

Add a text box named txtLineCnt to the group footer section
and set its Control Source expression to =Count(*)

Then use this line of code in the footer section's Format
event procedure:
Cancel = (Me.txtLineCnt = 1)

 

[BOONER]

Add a text box named txtLineCnt to the group footer section
and set its Control Source expression to =Count(*)

Then use this line of code in the footer section's Format
event procedure:
Cancel = (Me.txtLineCnt = 1)

I am getting the error "The object doesn't contain the automation object
'Cancel'

 

[Marshall Barton]

Since I can't imagine how that error can occur if you used
it as written in the place I said to put it. There's pny a
couple of things I can guess at.

Maybe you put it in the OnFormat property, instead of the
Format event procedure?

Maybe you put it in the Format event procedure, but modified
the code in an inappropriate way?

 

[BOONER]

Thanks a lot Marshall.

I was placing the code in the On Format Property instead of the event
procedure.

Since I can't imagine how that error can occur if you used
it as written in the place I said to put it. There's pny a
couple of things I can guess at.

Maybe you put it in the OnFormat property, instead of the
Format event procedure?

Maybe you put it in the Format event procedure, but modified
the code in an inappropriate way?
--
Marsh
MVP [MS Access]

I am getting the error "The object doesn't contain the automation object
'Cancel'