MS Access 2000, Report Code.

---------------------------------------
Option Compare Database

Private Sub GroupFooter0_Print(Cancel As Integer, PrintCount As Integer)

Debug.Print Me.Region.Value

If Me.Region.Value = "CORP" Then
Me.GroupFooter0.Visible = False
Else
Me.GroupFooter0.Visible = True
End If

End Sub
-----------------------------------------------------

IN print preview, the Group footer is still VISIBLE, and the Debug.Print shows CORP in the immediate window. . .

I have other reports where the first occurance in the report does NOT work, and all other occurances work. What is the deal with the first occurance in the reports?

thanks
sportsguy

i was executing On Print, and I should execute it On Format. . . .

such an idiot!

sg :eek: