Microsoft KB Archive/295254

= ACC2002: Cannot Bind a List Box to a Boolean Field on a Data Access Page =

Article ID: 295254

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



Steps to Reproduce the Behavior
 Open the sample database Northwind.mdb. Create a new data access page in Design view. 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. Drag the following fields to the data access page:

Product Name

SupplierID

Discontinued

 Disable the Control Wizards in the toolbox, and then add a combo box to the data access page.</li> Right-click the combo box, and then click Element Properties.</li> In the property sheet, click the Data tab.</li> In the ListRowSource property, click the Products table.</li> In the ControlSource property, click Discontinued.</li> In the ListBoundField property, click Discontinued.</li> In the ListDisplayField property, click Discontinued.</li> Close the property sheet.</li> View the data access page in Page view.</li> Make a selection in the combo box.</li></ol>

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.

Additional query words: pra, Boolean, combobox, listbox, data access page

Keywords: kbbug kbnofix KB295254

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.