Solved

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

Posted on 2012-03-28
3
387 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

622 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