CheckBox.TripleState Property (Access)
You can use the TripleState property to specify how the specified control will display Null values. Read/write Boolean.
Syntax
expression .TripleState
expression A variable that represents a CheckBox object.
Remarks
The Null property uses the following settings.
Setting |
Description |
|---|---|
True |
The control will cycle through states for Yes, No, and Null values. The control appears dimmed (grayed) when its Value property is set to Null. |
False |
(Default) The control will cycle through states for Yes and No values. Null values display as if they were No values. |
This property can be set in any view.
Example
The following example displays a message describing in detail the state of a check box named "Check1" on the form "frmOperations".
Dim strTripleState As String
strTripleState = Forms.Item("frmOperations").Controls.Item("Check1").TripleState
Select Case strTripleState
Case True
MsgBox "For Check1, TripleState = " & strTripleState & _
". The control will cycle through states for Yes, No, " & _
"and Null values. The control appears dimmed (grayed) " & _
"when its Value property is set to Null."
Case False
MsgBox "For Check1, TripleState = " & strTripleState & _
". The control will cycle through states for Yes and No " & _
"values. Null values display as if they were No values."
Case Else
MsgBox "Can't determine the TripleState property for Check1."
End Select