Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a form with Mutually Exclusive Option Radio Buttons
How do I make a form with Mutually Exclusive Option Radio Buttons? I am
trying to create a form that will constrain the person filling in the data to chose from only available choices. Such as only choosing Yes, No, or N/A, or from 1 through 10 on a survey of agreement to disagreement. This would help in keeping the data cleansed for going into a database. How do I do that? Please help me figure this one out. It seems too simple to not be doable. Thanks, Mark |
#2
|
|||
|
|||
G'Day Mark,
Option buttons are ALREADY mutually exclusive. If you have two or more option buttons on a userForm then setting any one will reset all the others. If you Group option buttons in Frames, then each Group will operate independently. By default, the value is set to 0, so that NO option buttons are (pre) selected. If you set the value of any one option button (per group) to 1 then that button will be set when the Form is displayed. -- Regards, Pat Garard Melbourne, Australia _______________________ "Mark" wrote in message ... How do I make a form with Mutually Exclusive Option Radio Buttons? I am trying to create a form that will constrain the person filling in the data to chose from only available choices. Such as only choosing Yes, No, or N/A, or from 1 through 10 on a survey of agreement to disagreement. This would help in keeping the data cleansed for going into a database. How do I do that? Please help me figure this one out. It seems too simple to not be doable. Thanks, Mark |
#3
|
|||
|
|||
Pat,
Thanks for the response, but I must be too dense to pick up what you are saying. Understand that my skills are limited in word, and I am trying to do this with the forms toolbar. I do not find where to insert buttons from, let alone make them mutually exclusive. I have copied some buttons from the MS templates, and they look and act great. But when the file is saved and then reopened, the neat features disappear. So what am I doing wrong. Mark "Pat Garard" wrote: G'Day Mark, Option buttons are ALREADY mutually exclusive. If you have two or more option buttons on a userForm then setting any one will reset all the others. If you Group option buttons in Frames, then each Group will operate independently. By default, the value is set to 0, so that NO option buttons are (pre) selected. If you set the value of any one option button (per group) to 1 then that button will be set when the Form is displayed. -- Regards, Pat Garard Melbourne, Australia _______________________ "Mark" wrote in message ... How do I make a form with Mutually Exclusive Option Radio Buttons? I am trying to create a form that will constrain the person filling in the data to chose from only available choices. Such as only choosing Yes, No, or N/A, or from 1 through 10 on a survey of agreement to disagreement. This would help in keeping the data cleansed for going into a database. How do I do that? Please help me figure this one out. It seems too simple to not be doable. Thanks, Mark |
#4
|
|||
|
|||
Hi Mark,
The Forms package in Office doesn't have any options buttons. The ones you copied from elsewhere are probably ActiveX controls from the Controls Toolbox (which you can get from View Toolbars). They're less than satisfactory unless you know how to program them in VBA. You can make checkboxes from the Forms toolbar behave like options buttons by following the instructions at http://www.word.mvps.org/FAQs/TblsFl...FmFldChbxs.htm -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org On Mon, 2 May 2005 16:52:01 -0700, "Mark" wrote: Pat, Thanks for the response, but I must be too dense to pick up what you are saying. Understand that my skills are limited in word, and I am trying to do this with the forms toolbar. I do not find where to insert buttons from, let alone make them mutually exclusive. I have copied some buttons from the MS templates, and they look and act great. But when the file is saved and then reopened, the neat features disappear. So what am I doing wrong. Mark "Pat Garard" wrote: G'Day Mark, Option buttons are ALREADY mutually exclusive. If you have two or more option buttons on a userForm then setting any one will reset all the others. If you Group option buttons in Frames, then each Group will operate independently. By default, the value is set to 0, so that NO option buttons are (pre) selected. If you set the value of any one option button (per group) to 1 then that button will be set when the Form is displayed. -- Regards, Pat Garard Melbourne, Australia _______________________ "Mark" wrote in message ... How do I make a form with Mutually Exclusive Option Radio Buttons? I am trying to create a form that will constrain the person filling in the data to chose from only available choices. Such as only choosing Yes, No, or N/A, or from 1 through 10 on a survey of agreement to disagreement. This would help in keeping the data cleansed for going into a database. How do I do that? Please help me figure this one out. It seems too simple to not be doable. Thanks, Mark |
#5
|
|||
|
|||
Jay,
Thanks for the help getting this to a form. There was a minor glitch due to the macro security being too high and disabling the macro, but once it was lowered the system works great. Thank you both for your help. regards, Mark "Jay Freedman" wrote: Hi Mark, The Forms package in Office doesn't have any options buttons. The ones you copied from elsewhere are probably ActiveX controls from the Controls Toolbox (which you can get from View Toolbars). They're less than satisfactory unless you know how to program them in VBA. You can make checkboxes from the Forms toolbar behave like options buttons by following the instructions at http://www.word.mvps.org/FAQs/TblsFl...FmFldChbxs.htm -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org On Mon, 2 May 2005 16:52:01 -0700, "Mark" wrote: Pat, Thanks for the response, but I must be too dense to pick up what you are saying. Understand that my skills are limited in word, and I am trying to do this with the forms toolbar. I do not find where to insert buttons from, let alone make them mutually exclusive. I have copied some buttons from the MS templates, and they look and act great. But when the file is saved and then reopened, the neat features disappear. So what am I doing wrong. Mark "Pat Garard" wrote: G'Day Mark, Option buttons are ALREADY mutually exclusive. If you have two or more option buttons on a userForm then setting any one will reset all the others. If you Group option buttons in Frames, then each Group will operate independently. By default, the value is set to 0, so that NO option buttons are (pre) selected. If you set the value of any one option button (per group) to 1 then that button will be set when the Form is displayed. -- Regards, Pat Garard Melbourne, Australia _______________________ "Mark" wrote in message ... How do I make a form with Mutually Exclusive Option Radio Buttons? I am trying to create a form that will constrain the person filling in the data to chose from only available choices. Such as only choosing Yes, No, or N/A, or from 1 through 10 on a survey of agreement to disagreement. This would help in keeping the data cleansed for going into a database. How do I do that? Please help me figure this one out. It seems too simple to not be doable. Thanks, Mark |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a "text form field" stay still so that when I type . | Microsoft Word Help | |||
How can I make a form field appear when a seclection is made from. | Page Layout | |||
How do I make "tab" go from form field to form field? | Microsoft Word Help | |||
Can you make a chart type of form in Word 2003 with form protecti. | Microsoft Word Help | |||
how do I make the cursor on a form go from field to field in the . | Tables |