Report "open" code runs - header format code doesn't

  • Thread starter Thread starter TomM
  • Start date Start date
T

TomM

I'm having a problem getting code in the "on Format" section of any report
header to run.

I created a simple, one table database and created a simple report based on
the table. I added the following code:

Private Sub Report_Open(Cancel As Integer)
MsgBox "open"
End Sub

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
MsgBox "rptHdr"
End Sub

The "Report_Open" code runs, the "ReportHeader_Format" code (and code for
other headers) never does.

The database is in a trusted location.
What's up?
 
Any you using Access 2007?

If so, you are probably opening the report in the new Report view. The
section events don't fire in this view. Try Print Preview instead.
 
Back
Top