ACC2000: Bound Combo Box Does Not Display Values

Article translations Article translations
Article ID: 223239 - View products that this article applies to.
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).

Expand all | Collapse all

On This Page

Symptoms

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.

Cause

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.

Resolution

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:

    Collapse this tableExpand this table
    Field NameData TypePrimary Key?
    MyPKAutonumberYes
    MyCharTextNo
    MyYesNoYesNoNo
  3. In Design view, add two records to the MyTable table:

    Collapse this tableExpand this table
    MyPKMyCharMyYesNo
    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:

    Collapse this tableExpand this table
    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.

References

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.

Properties

Article ID: 223239 - Last Review: October 26, 2013 - Revision: 3.0
Applies to
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbclientserver kbprb KB223239

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com