ACC2002: Cannot Bind a List Box to a Boolean Field on a Data Access Page (295254)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295254
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

The choice you make in a list box or a combo box on a data access page does not appear in the list box or the combo box. Additionally, no data is displayed in the list box when you browse through records.

CAUSE

The list box or the combo box is based on a Boolean or a Yes/No field.

RESOLUTION

Set the Format property of the list box or the combo box to True/False. To do so, follow these steps:
  1. In Design view of the data access page, right-click the combo box.
  2. Click Element Properties.
  3. Click the Data tab.
  4. Click in the Format property, and then click True/False in the drop-down list.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Create a new data access page in Design view.
  3. Expand the Products table in the field list to see all fields. If the field list is not displayed, click Field List on the View menu.
  4. Drag the following fields to the data access page:

    Product Name
    SupplierID
    Discontinued

  5. Disable the Control Wizards in the toolbox, and then add a combo box to the data access page.
  6. Right-click the combo box, and then click Element Properties.
  7. In the property sheet, click the Data tab.
  8. In the ListRowSource property, click the Products table.
  9. In the ControlSource property, click Discontinued.
  10. In the ListBoundField property, click Discontinued.
  11. In the ListDisplayField property, click Discontinued.
  12. Close the property sheet.
  13. View the data access page in Page view.
  14. Make a selection in the combo box.
Note that the Discontinued check box changes according to the selection that you make in the combo box. However, the value that you select does not appear in the combo box. If you scroll through the records, the value that you selected in the combo box does not appear.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbbug kbnofix KB295254
©2004 Microsoft Corporation. All rights reserved.