ToggleButton.TripleState Property (Access)
TOC
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

ToggleButton.TripleState Property (Access)

You can use the TripleState property to specify how the specified control will display Null values. Read/write Boolean.

expression .TripleState

expression A variable that represents a ToggleButton object.

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.

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 

Show:
© 2016 Microsoft