ACC2000: Bound Combo Box Does Not Display Values (223239)
The information in this article applies to:
This article was previously published under Q223239 Moderate: Requires basic macro, coding, and interoperability
skills.
This article applies only to a Microsoft Access project (.adp).
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. REFERENCESFor 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.
Modification Type: | Major | Last Reviewed: | 11/21/2002 |
---|
Keywords: | KbClientServer kbprb KB223239 |
---|
|