Triple state in check box

[Guest]

Hi!

So that it serves triple state in check boxes, please.
Thanks in advance.
an

 

[Allen Browne]

To create a field that stores True, False, or Null, open your table in
design view, and make a field of type Number (not yes/no.) In the lower pane
of table design set these properties:
Size Integer
Default Value 0
Display Control Check Box

The Display Control is on the Lookup tab.
The zero for default value is only if you want False as default.

Now when you add this field to a form, you will get a check box, and you can
set its Triple State property.

If you are using Access 2003 on Windows XP, the third state does not show up
as visually distinct unless you uncheck:
Tools | Options | Forms/Reports | Use themed controls

 

[Guest]

Ok AB,

Many thanks you for your explanation.
an

To create a field that stores True, False, or Null, open your table in
design view, and make a field of type Number (not yes/no.) In the lower pane
of table design set these properties:
Size Integer
Default Value 0
Display Control Check Box

The Display Control is on the Lookup tab.
The zero for default value is only if you want False as default.

Now when you add this field to a form, you will get a check box, and you can
set its Triple State property.

If you are using Access 2003 on Windows XP, the third state does not show up
as visually distinct unless you uncheck:
Tools | Options | Forms/Reports | Use themed controls