How do I make no selection in an Access Option Group once a selection is made

Posted on 2009-02-10
Last Modified: 2013-11-28
Hello, I have an option group on a form in Access with 2 choices.  If a user selects one of the choices by mistake, they would like to 'unselect' the option so that no option is selected.  Any ideas?
Question by:Monterey
    LVL 92

    Accepted Solution

    Hello Monterey,

    If "none" is a valid choice, I would just make that one of the options...


    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)

    Me.YourOptionGroupName = Null


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    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…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    794 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

    18 Experts available now in Live!

    Get 1:1 Help Now