ACC1x: How to Display Yes/No Choices in a Combo Box or List Box

• Microsoft Access versions 1.0, 1.1

SUMMARY

This article describes how to use a list box or a combo box to display Yes and No, True and False, or On and Off selections for a field with a Yes/No data type.

MORE INFORMATION

When you use a Yes/No data type, one of three formats may be applied: Yes/No, True/False, or On/Off. However, list boxes and combo boxes do not display these formats. Instead, the actual value of the Yes/No field will be displayed. The actual value of a Yes/No field is either -1 or 0, no matter which format is applied.

In order to display values with one of the formats listed above in a list box or a combo box, the following properties must be set for the list box or the combo box:

   Object: combo box
   -------------------------
   RowSourceType: Value List
   RowSource: -1;Yes;0;No
   ColumnCount: 2
   ColumnWidths: 0 in; 1 in
   BoundColumn: 1
   List Rows: 2

   Object: list box
   -------------------------
   RowSourceType: Value List
   RowSource: -1;Yes;0;No
   ColumnCount: 2
   ColumnWidths: 0 in; 1 in
   BoundColumn: 1

REFERENCES