Yes/No Field

B

Bassel

May be this is a simple question, but I don't know how to solve this problem.
I have a table with 700 records. I added a new Yes/No field to it. I set the
Display Control to Text Box. I left the Default value blank.
When I opened the table , I found that all records have "No" value.
I was expecting Null, not No.
Can you help me solve this problem.
 
R

Rick Brandt

Bassel said:
May be this is a simple question, but I don't know how to solve this
problem. I have a table with 700 records. I added a new Yes/No field
to it. I set the Display Control to Text Box. I left the Default
value blank.
When I opened the table , I found that all records have "No" value.
I was expecting Null, not No.
Can you help me solve this problem.
Click to expand...

Yes/No fields in Access don't support Null. If you need Null use an Integer
field. You can still bind to CheckBoxes and ToggleButtons just as you would
with a Yes/No in forms, but datasheets will not show a checkbox.
 
V

Van T. Dinh

AFAIK, Boolean Fields have only 2 states, i.e. True / False. If no default
is set, it is default to False.

If you want True / False / Null, use data type like Bit data type and use 0
for False / No, 1 for True / Yes.
 
Top