You are currently offline, waiting for your internet to reconnect

ACC2000: Bound Combo Box Does Not Display Values

This article was previously published under Q223239
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

After you upsize a form that has a combo box bound to a Yes/No field in a table, the combo box no longer displays data in a Microsoft Access project. When you try to select a value with the combo box, the value that you specify is saved, but it is not displayed.
When you upsize a database to SQL Server or MSDE, Yes/No fields in your tables are automatically converted to bit columns on SQL Server. If you bind a combo box to a bit column in an Access project, you must display and store Boolean values as True or False, not as -1 or 0.
Modify the RowSource property of your combo boxes, replacing -1 with True, and 0 with False.
More information
The following steps reproduce and correct the behavior described in the "Symptoms" section of this article.

Steps to Reproduce Behavior

  1. Create a new database named MyTestDatabase.
  2. Create the following table in the MyTestDatabase database, and then save the table as MyTestTable:

    Field NameData TypePrimary Key?
  3. In Design view, add two records to the MyTable table:

    1First RecordYes
    2Second RecordNo
  4. Close the table, and create a new form. Base the form on the MyTable table.
  5. Drag the MyPK and MyChar fields from the field list to the detail section of your new form. (If you cannot see the field list, click Field List on the View menu.)
  6. If the toolbox is not visible, open it by clicking Toolbox on the View menu.
  7. Make sure that the Control Wizards are not active (the button in the toolbox does not appear pressed in), and then select a combo box.
  8. Place the combo box in the detail section of the form.
  9. Modify the properties of the combo box as follows:

    Property NameValue
    Control SourceMyYesNo
    Row Source TypeValue List
    Row Source"True Value";-1;"False Value";0
    Bound Column2
  10. Save the new form as MyForm.
  11. Open the form in Form view. Note that either "True Value" or "False Value" is displayed in the combo box.
  12. Close the form.
  13. Run the Upsizing Wizard by clicking the Tools menu, pointing to Database Utilities, and then clicking Upsizing Wizard.
  14. Upsize the MyTestDatabase database, choosing to migrate all tables to Create a new client-server application.
  15. After the upsizing process is complete, examine and close the upsizing report. When you close the report, the new Access project that is created for you by the wizard opens automatically.
  16. Open the MyForm form in the Access project. Note that no values are displayed in the combo box.
  17. Open the MyForm form in Design view, and change the Row Source property of the combo box to the following:
       "True Value";True;"False Value";False					
  18. Save the form, and then reopen it in Form view. Note that values are now displayed in the combo box.
For more information about combo boxes, click Microsoft Access Help on the Help menu, type combo box in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
pra prb

Article ID: 223239 - Last Review: 10/26/2013 18:23:00 - Revision: 3.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbclientserver kbprb KB223239