MS Access "On Print" Event: Where can I find i This?

Posted on 2009-04-17
Last Modified: 2012-06-21
Dear Experts:


I would like to locate "On Print"  event on MS Report Report.

But I cannot find it.


Question by:duta
    LVL 119

    Assisted Solution

    by:Rey Obrero
    that event is available for the report sections
    report header
    page header
    report footer etc.,

    of the report
    LVL 65

    Accepted Solution

    Do you mean how to get to it?

    1. open up your report in design view
    2. if you dont see the properties window, click on View/Properties
    3. In the properties window, the top has a dropdown, default is probably Report. Change it to Detail (one part that can handle on print events)
    4. Within the list of tabs (Format, Data, Event, Other, All), click on the Events tab
    5. You should now see the On Print event. To build an update, click on the button with ... on the right hand side. To add vba, ensure you select code builder

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now