Solved

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

Posted on 2012-03-28
3
383 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…

756 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