TripleState Property
You can use the TripleState property to specify how a check box, toggle button, or option button will display Null values. Read/write Boolean.
expression.TripleState
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The TripleState property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| Yes | 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. |
| No | 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