Yes/No with no default

A

alicia

I have 7 questions that need to be answered for each
record in a table named "event". These questions are in
the event table as a yes/no data type. I have a form
based on this table with an option group for each
question with a "yes/no" option. The form will
automatically show the default value for the yes/no
fields in the option groups (I did not specify a default
value either). I want all fields to be null until a user
updates it. I tried typing "null" in the default value
in the table but that did not work. Is there a way to
make the field(s) remain null until a user updates it to
a -1 or 0 (yes/no)?
Thanks! Alicia
 
B

Bruce M. Thompson

I have 7 questions that need to be answered for each
record in a table named "event". These questions are in
the event table as a yes/no data type. I have a form
based on this table with an option group for each
question with a "yes/no" option. The form will
automatically show the default value for the yes/no
fields in the option groups (I did not specify a default
value either). I want all fields to be null until a user
updates it. I tried typing "null" in the default value
in the table but that did not work. Is there a way to
make the field(s) remain null until a user updates it to
a -1 or 0 (yes/no)?

A Boolean field always contains either a True or False value - it cannot contain
a Null. If you need to assign a default value of Null to your field, you will
need to change it to a regular number field.
 
G

Gina

A yes/no field has to contain a default value whether you want it or not.
If you want your users to be sure they selected the right option on the
form, net to each yes/no field place in the Control Source of the text box
type:

IIf([NameOfYes/NoField]=0,"No","Yes")

I have mine show up in red... This way the user sees what was selected and
whether it is what they wanted selected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top