Report Footer data

[JonWayne]

In a section footer, I need the label (or textbox displaying label data) to
read "SubTotal " <Section Name>. What contol should I use and how do I set
its properties to acheive that?

Thanks

 

[Brendan Reynolds]

Interesting question. Haven't tried this in a 'real world' app, but based on
some admittedly brief tests, this seems to work in Access 2003 (haven't
tested with earlier versions) ...

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

Dim lbl As Label
Set lbl = Me.lblTest
lblTest.Caption = lblTest.Parent.Section(lblTest.Section).Name

End Sub