Option group not behaving properly on form

[ntradd]

Hi: I have a problem with an option group on a form in Access 2007. When I run the form, I can select an option from the option group, but if I try to select a different option instead, the form does not allow this. I either have to run the original option and come back to the form, or close the form and start again. I've never seen an option group behave like this before. I presume it's a setting of some kind that needs to be changed, but I haven't been able to determine what's causing this. Any ideas? Thanks.

[Missinglinq]

Is the Option Group Bound or Unbound?

What code, if any, do you have behind the OG?

Although we usually think of Forms or entire Databases when we speak of corruption, individual Controls, such as Option Groups, can and do become corrupted. The test and the fix are one and the same; deleting the Control then re-creating it! If it was corrupt, you've verified the fact and solved the problem! If not, you've only lost a minute or two!

Linq ;0)>

[ntradd]

It's an unbound control. It lists options for searching a database. After an option is selected, a command button acts on the option, using a macro. There is no code. There's a lot of formatting associated with the control in the form, so recreating it would take more than a few minutes of work, but I may try that.

[Missinglinq]

...There's a lot of formatting associated with the control in the form...

Can you explain this 'formatting' in more detail?

Linq ;0)>

[ntradd]

It's just cosmetic--the option group is part of a recessed box with borders, etc., but I may be able to delete the option group without disturbing the decorations

[Missinglinq]

...It's just cosmetic...

That being the case, I would go with the assumption that it is a corrupt Control. To test this out, I would:

• Leave the original Option Group in place
• Create a new Option Group
• Go into the Macro you're using and replace the original Option Group name with the name of the newly created Option Group
• Now, without adding all of your foo foo formatting stuff, see if the Option Group functions as it should.

If the Option Group does work as it should:

• Close the Database
• Copy the Database file
• Place the original Database file in a safe location

Now, using the newly created copy of your app

1. Delete the original Option Group
2. Proceed, once again, to modify the newly created Option Group
3. Apply one format
4. Check for functionality
5. Repeat Steps #3 and #4 until all formatting is complete

If this has been successful, relax, you're home free:

• Rename the original Database file to something else
• Rename the newly created Database file using the original name of the original file

If this has not been successful, i.e. it bombed, again, make a note of what type of formatting you were attempting to do with Step #3, above, that caused it to bomb, then, starting once again with the original Database file, go through the whole thing again, stopping just short of the formatting that caused the problem.

Hopefully you won't have to do this! If the facts are as reported, I can't see anything other than corruption as the cause of this.

Linq ;0)>

[ntradd]

This morning I stumbled across the solution to this problem while I was looking for help on option groups. The bug is documented at http://support.microsoft.com/kb/926713. Apparently in Access 2007, option groups don't work when they're superimposed over a rectangle with the BackStyle property set to Normal, and when another control is superimposed over the option group. I changed some of my "foo foo" formatting and now everything works. Thanks for your suggestions.

[Missinglinq]

Glad you got it working.