Data Entry

A

adarling

I've created a table in which I have two columns that are yes or no answers
(SendInfo & ActiveMember). I only want to fill in the fields that I have
definite yes or no answers on the completed questionnaires I've received - I
just discovered Access is filling in the fields I've left blank which I
absolutely do not want to happen. Is there a fix for this?
 
R

Rick B

A checkbox in a yes/no field is either Yes, or No.

You can make this a numeric field that can contain more than two values and
set up a TRIPLE STATE checkbox in your form. The value could then be "Yes"
(checked) "No" (Blank) and "Null" (Grayed out).

If you need more help, post back and let us know.
 
Top