A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Modify existing Option Group structure?



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2007, 02:23 PM posted to microsoft.public.access.forms
CW
external usenet poster
 
Posts: 701
Default Modify existing Option Group structure?

I used the Option Group Wizard to create a customer satisfaction record page
with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
There's an underlying table to store the scores, and a query to report upon
them.
It all looked great, then the boss asked me to add another option button for
N/A, which would score 0.
How do I modify the structure on the form to add a further checkbox option?
Thanks
CW
  #2  
Old October 26th, 2007, 04:03 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default Modify existing Option Group structure?

On Fri, 26 Oct 2007 06:23:01 -0700, CW wrote:

I used the Option Group Wizard to create a customer satisfaction record page
with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
There's an underlying table to store the scores, and a query to report upon
them.
It all looked great, then the boss asked me to add another option button for
N/A, which would score 0.
How do I modify the structure on the form to add a further checkbox option?
Thanks
CW


Open the form in design view.
Click on the ToolBox Tool button.
Select the radio button and drag it inside the Option Group frame.
The button will have an Option Value of 5.
Select this new button.
Display it's property sheet.
Click on the Data tab.
Set the Option Value to 0.
Save the changes.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #3  
Old October 26th, 2007, 04:06 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Modify existing Option Group structure?

Open the form in design view.
Select the appropriate control type for the options in your existing group.
buttons, check boxes, or whatever the other options are. Put it in the list.
In the properties dialog, make the Caption N/A and the Option Value 0.
--
Dave Hargis, Microsoft Access MVP


"CW" wrote:

I used the Option Group Wizard to create a customer satisfaction record page
with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
There's an underlying table to store the scores, and a query to report upon
them.
It all looked great, then the boss asked me to add another option button for
N/A, which would score 0.
How do I modify the structure on the form to add a further checkbox option?
Thanks
CW

  #4  
Old October 26th, 2007, 05:28 PM posted to microsoft.public.access.forms
CW
external usenet poster
 
Posts: 701
Default Modify existing Option Group structure?

Oh dear, if it's that easy I'm feeling stoopid now.
Many thanks
CW

"Klatuu" wrote:

Open the form in design view.
Select the appropriate control type for the options in your existing group.
buttons, check boxes, or whatever the other options are. Put it in the list.
In the properties dialog, make the Caption N/A and the Option Value 0.
--
Dave Hargis, Microsoft Access MVP


"CW" wrote:

I used the Option Group Wizard to create a customer satisfaction record page
with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
There's an underlying table to store the scores, and a query to report upon
them.
It all looked great, then the boss asked me to add another option button for
N/A, which would score 0.
How do I modify the structure on the form to add a further checkbox option?
Thanks
CW

  #5  
Old October 26th, 2007, 05:28 PM posted to microsoft.public.access.forms
CW
external usenet poster
 
Posts: 701
Default Modify existing Option Group structure?

Oh dear, if it's that easy I'm feeling stoopid now.
Many thanks
CW


"fredg" wrote:

On Fri, 26 Oct 2007 06:23:01 -0700, CW wrote:

I used the Option Group Wizard to create a customer satisfaction record page
with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
There's an underlying table to store the scores, and a query to report upon
them.
It all looked great, then the boss asked me to add another option button for
N/A, which would score 0.
How do I modify the structure on the form to add a further checkbox option?
Thanks
CW


Open the form in design view.
Click on the ToolBox Tool button.
Select the radio button and drag it inside the Option Group frame.
The button will have an Option Value of 5.
Select this new button.
Display it's property sheet.
Click on the Data tab.
Set the Option Value to 0.
Save the changes.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.