Check box or yes/no field storing text in a field

  • Thread starter Thread starter John Devine
  • Start date Start date
J

John Devine

I am creating a form that will have 30 different fields.
Each field will represent a choice of a phrase. I am
thinking of using a radio button or a check box or maybe a
yes/no field. Each field will have only two possible
states, true or false. If the user clicks the button,
specific text is stored in the field, if he doesn’t click
on it the field is left blank.
How can I accomplish this?
 
John,
Regarding: > I am
thinking of using a radio button or a check box or maybe a
yes/no field. Each field will have only two possible
states, true or false. <
Click to expand...

A check box is a Yes/No field.
If there are only 2 choices, that would be an appropriate solution to what
you wish to do.
However, a Check Box field only stores a number, -1 for Yes, 0 for No.

Go ahead and use the checkbox for each of the 30 fields.
Display the 2 choices as text in the check box's label.
Store the check box value in the table (as a -1 or 0).

Then, when you need to print out the results, use an unbound control where
that field's result should appear.
Set the control's control source to the appropriate Check box field.
Place the following in the control's Format property:
;"Text if Field checked";"Text if field NOT checked"

Each field will then display the appropriate text, not the -1 or 0.
 
Fred,
Thank you for the help. I have been in VPN vs firewall
hell for a while and have not had time to look at the post.
Thanks,
Jack
 
Back
Top