How to trigger the Format event for a report section

[Petrol]

So MS isn't interested in advice or suggestions from MVPs?

[NeoPa]

MVPs must, if they feel any responsibility at all, be far more considered before making their opinions as to how things should work known to the A-Team.

Experience (should have) taught us by now that, just because the reasoning for something isn't clear & obvious to us, doesn't mean that they got it wrong. On most occasions when we bring up anomalies we are privileged to hear the reasoning that they were working to which is often based on data we aren't generally privvy to - or simply just a way of thinking that hadn't occurred to us.

As for their responsiveness to us I'm very proud to say that much of what you see added to the product in recent years was prompted & assisted by some of my fellow MVPs. I won't name names here but scanning some of their blogs & resources will show how they've been at the heart of much of the newer functionality. I certainly don't feel that our contributions are ignored or otherwise undervalued.

[isladogs]

I've only just noticed this thread.
Neither the OnFormat nor OnPrint events have ever worked in Report view

The full quote from the MS Learn article states:

The Format event occurs when Access determines which data belongs in a report section, but before Access formats the section for previewing or printing.

Report view just gives a visual representation of the report contents. It neither previews nor prints so the Format event doesn't fire.

[Petrol]

Yes, the user will display the report on screen and then print it - either to PDF for email or to paper - at which time the On Format proc then adds the exrta line of text where necessary. Fortunately the person producing the report on screen doesn't need the full details, but sends the printed report to the person who needs the information with full details.