Solved

Add to option group

Posted on 2013-01-30
15
460 Views
Last Modified: 2013-01-30
If I have an option group on a form that I created through the wizard. How can I add to the option group after it is created?

Thanks!
0
Comment
Question by:cansevin
[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
  • 8
  • 7
15 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836541
drag a control (radio button, checkbox, toggle) from the design ribbon into the option group.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836564
actually, it's not a drag and drop.

Click the item in the ribbon (menu),  Then hover over the option group (the group should go black) and click again.

If you drop the control outside the group, you cannot simply drag it over the group, you have to cut it, select the border of the group, and paste it.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 38836565
See image.

opt in ...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 38836567
Actually ... you can drag and drop ... see image above ...

mx
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836597
Joe,  What version of access are you using (I'm using 2007 and could not get the D/D to work)?  How did you get the controls down the right side of your screen.
0
 
LVL 75
ID: 38836628
Well ... this is A2003 and that is the Controls Tool Bar - you might need to make it visible.  And sometimes ... you have to 'click' the option control twice (not double click) - to make it come 'alive' - such that it can be dragged.

Let me try in A2010 ... standby ...
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836658
After all these years, learn something new

It's been a long time since I've used 2003, and I had forgotten that we had the ability to move the controls toolbar around.
0
 
LVL 75
ID: 38836663
I was able to also do this in A2010

First, you have to right click over the Option Button control on the Ribbon - and select 'Drop Multiple Controls'.
This seems to enable drag and drop - for a 'session' ... IE, you can drag N number of option buttons onto the option group frame.  If you came back later, seems you have to repeat this right click process.

mx
0
 
LVL 75
ID: 38836665
Dude ... this WHY ... we are on EE :-)

Also remember this key saying:

When In Doubt, Right Click !
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836693
"First, you have to right click over the Option Button control on the Ribbon - and select 'Drop Multiple Controls'."

This is not available in 2007.  right click
Although the two-click - drag/drop does seem to work.

And the single left click, move mouse, Left click does work.
0
 
LVL 75
ID: 38836715
In the image above ... are you SURE you are right clicking over the Option Button control itself ?  I get what you show IF ... I just click over a blank area of the ribbon - wherein a control is not actually highlighted ...

mx
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836756
Yep, I'm sure.  As soon as I mouse over the radio button (actually any of the controls), I see a small, see a control tip text (but it looks like a button).mouse overNotice that the radio button is selected in the image.

But when I right click on the controls, I get the image above (in A2007).
0
 
LVL 75
ID: 38836780
(finally was able to get a capture)

Opt IN
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38836836
I use SnagIt for my screen captures, lets me define the screen area or window, and it pops up when I click the PrintScreen button.  

Is that the 2010 ribbon?  Although I have 2010 on my Win7 laptop, it is the 64 bit version (necessary for a the only client using 2010, so far), so I rarely use it.
0
 
LVL 75
ID: 38836927
Yes 2010 ribbon.
I have Snagit, but I still use RoboScreenCapture ... for a moment, it was blowing out the right click message.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

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