Why can't I immediately change my choice in an Access form's "option group" control?

Posted on 2012-03-28
Medium Priority
Last Modified: 2012-08-13
I am developing an Access 2007 "project" (.adp) as a front-end to a SQL Server 2007 Express database.

On many of my Access forms I make use of "option group" controls that offer the user a group of radio buttons to choose from.

In most cases, these options can immediately be re-selected, by which I mean the user can select one radio button then select another one instead then select another one instead, etc. without ever leaving that control.

However, I have a couple of similar "option group" controls that do not allow this immediate change of mind. If one radio button is selected, another cannot be immediately selected instead. The user has to click on another control on the form before returning to the "option group" control to select a different radio button.

I have compared the "properties" of the different controls but they seem to be the same.
The only other observation is that the "problem" "option group" controls are both on the same "page" of a multi-tab control and the "good" "option group" controls are on different "pages". But I can't see any significant differences between the "page" properties either.

It is a minor inconvenience but I would like to understand what is going on.
Any ideas anyone?
Question by:colinasad
  • 2
LVL 61

Accepted Solution

mbizup earned 2000 total points
ID: 37777101
The option group should be immediately changeable.

Is there any VBA code or macros that might be affecting this?

Or hidden controls that might be interfering with it ?

If neither of the above, try repositioning or recreating your control.

Author Closing Comment

ID: 37777184
Many thanks for the very prompt response, mbizup.

One of the option groups had a couple of "label" controls laid on top of it which I make visible or invisible depending on which of the radio buttons is selected. When I dragged these labels to the side, off the "option group" control, that control allowed me to do the immediate changing I wanted.

But, the other "option group" control that was giving me the same problem on the same page did not have any obviously overlapping controls. However when I selected that control and "brought it to the front" it worked as I wanted.

It looks like "option group" controls like to be at the front of the crowd!
Many thanks.
LVL 61

Expert Comment

ID: 37777203
<< "option group" controls like to be at the front of the crowd!>

There you go!

The reason for that is that an "option group", despite having multiple checkboxes or radio buttons, is really a single control.  So if there is another control on top of it, it will affect your ability to use it (even if the checkboxes/radiobuttons are not obscurred by the other control).

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

588 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