Applies to
|
CheckBox Object |
|
OptionButton Object |
|
ToggleButton Object |
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. |
Note: You can set the TripleState property by using a control's property sheet, a macro, or Visual Basic for Applications (VBA) code.
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
