Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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
?
395 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

580 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