check boxes

K

Kim Doe

Hello

I am trying to create a form in Access 2000 that has triple state chec
boxes for a control that has data type that I've marked as "genera
number." (An idea I thought was possible after reading a previou
posting:
http://www.pcreview.co.uk/forums/thread-1678168.php)

But, checkboxes don't seem to be an option. Do I have to change my dat
type?

Thank you
 
A

Allen Browne

Open the table where the yes/no field is.
Change the field to a Number type.

The triple state should then work.

The problem is that Yes/No fields in Access cannot store Null, so the 3rd
state is not available. Since Access uses -1 for True, and 0 for False, you
can use a Number field to store -1, 0, and Null.
 
K

Kim Doe

Thanks, Allen. Unfortunately, the problem is that in the table my fiel
IS number type and I have this problem.

I am opening a form thru "AutoForm: Columnar" and when I right clic
the field that I want to "change to" a checkbox, "checkbox" is greye
out. Is there other checkbox criteria
 
A

Allen Browne

You probably can't change the text box into a check box.

In form design view, delete the text box.
Then click the check box in the Toolbox (View menu).
Then drag the field from the Field List (View menu) onto the form.

That should give you a check box bound to the number field.
If not, you can set the Properties of the text box, i.e. set its
ControlSource to the field name.

You may also need to set the Tab Order property (View menu) so that you
visit them in the right order.
 
K

Kim Doe

That worked! Great! One more question: In "properties" of the check box
I wrote "Null" in Default value, but as soon as I start filling ou
anything for that case, the Null (greyed out) switches to No (white)
How to keep a Null value unless I mark otherwise?
 
A

Allen Browne

Leave the Default Value property of the check box blank.

Open the table in design view, select the Number field, and in the lower
pane, remove the zero from the Default Value.
 
Top