Yes/No with no default

[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

[Lynn Trapp]

Set the TripleState property of your checkbox to Yes

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

"alicia" <alicia...@comcast.net> wrote in message
news:035001c37e07$149ab560$a101...@phx.gbl...

[Bruce M. Thompson]

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.

--
Bruce M. Thompson, Microsoft Access MVP
bthm...@mvps.org (See the Access FAQ at http://www.mvps.org/access)
>> NO Email Please. Keep all communications
within the newsgroups so that all might benefit.<<

[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.

"alicia" <alicia...@comcast.net> wrote in message
news:035001c37e07$149ab560$a101...@phx.gbl...