Prevent users from closing an access form by clicking on the 'X"

Posted on 2011-10-18
Last Modified: 2012-05-12
How can I prevent a user form clicking on the x to close a form. I have a save and new button as well as a cancel button. However, once a field is entered in the form and they select the x, i receive an error.
Question by:dplowman
    LVL 25

    Expert Comment

    Microsoft had a KB on this back with Access 2000:
    LVL 119

    Expert Comment

    by:Rey Obrero
    follow the instruction from this link

    Prevent Access from closing
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    see my response here:
    LVL 56

    Accepted Solution


     Set the close button property to no.

    LVL 119

    Expert Comment

    by:Rey Obrero
    oh if it is just the form, see Jim's comment..

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    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…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now