Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-03-28
3
Medium Priority
?
392 Views
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?
0
Comment
Question by:colinasad
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
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.
0
 

Author Closing Comment

by:colinasad
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.
0
 
LVL 61

Expert Comment

by:mbizup
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).
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

886 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