Yes/No data type (Format property)
Applies to: Access 2013 | Access 2016
You can set the Format property to the Yes/No, True / False, or On/Off predefined formats or to a custom format for the Yes/No data type.
Settings
Microsoft Access uses a check box control as the default control for the Yes/No data type. Predefined and custom formats are ignored when a check box control is used. Therefore, these formats apply only to data that is displayed in a text box control.
Predefined formats
Yes, True, and On are equivalent, as are No, False, and Off. If you specify one predefined format and then enter an equivalent value, the predefined format of the equivalent value will be displayed. For example, if you enter True or On in a text box control with its Format property set to Yes/No, the value is automatically converted to Yes.
Custom formats
The Yes/No data type can use custom formats containing up to three sections.
| Section | Description |
|---|---|
| First | This section has no effect on the Yes/No data type. However, a semicolon (;) is required as a placeholder. |
| Second | The text to display in place of Yes, True, or On values. |
| Third | The text to display in place of No, False, or Off values. |
Example
The following example shows a custom yes/no format for a text box control. The control displays the word "Always" in blue text for Yes, True, or On, and the word "Never" in red text for No, False, or Off.
;"Always"[Blue];"Never"[Red]
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.