Reply
 
Thread Tools Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default 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   Report Post  
Pat Garard
 
Posts: n/a
Default

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   Report Post  
Mark
 
Posts: n/a
Default

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   Report Post  
Jay Freedman
 
Posts: n/a
Default

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   Report Post  
Mark
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a "text form field" stay still so that when I type . Sadebelle Microsoft Word Help 1 April 8th 05 10:12 PM
How can I make a form field appear when a seclection is made from. Dbltap Page Layout 3 March 4th 05 10:47 PM
How do I make "tab" go from form field to form field? DLS Microsoft Word Help 2 February 16th 05 08:44 PM
Can you make a chart type of form in Word 2003 with form protecti. libangell Microsoft Word Help 1 December 12th 04 12:17 AM
how do I make the cursor on a form go from field to field in the . tree_tender Tables 1 December 11th 04 03:00 AM


All times are GMT +1. The time now is 01:49 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"