ReportHeader_Format Firing Twice?

  • Thread starter Thread starter R De Leon
  • Start date Start date
R

R De Leon

I am relatively new to Access and I am working with a
report. The report request a parameter when it is opened
and I want some action taken based on the parameter
value. Very simple, I think.

I am using the ReportHeader_Format sub, but it seems to
be firing twice when I open the report. What controls
the firing of this event?

Any help is appreciated.

Rene'
 
The number of times the Format events fire is really unpredictable.

It is governed by many factors, including which sections are in the report,
how large they are, whether they CanShrink or CanGrow, whether they are
supposed to KeepTogether, whether they RepeatSection, whether there is a
ForceNewPage, whether you are toggling the section's Visible property, or
changing the runtime properties like PrintSection, MoveLayout, or ...

It is probably enough to know that the Format event for sections can fire
multiple times, and that the FormatCount may even be affected by whether the
Retreat event fired also.
 
Back
Top