ACC2000: How to Include a Null Selection in a Combo Box List (208707)
The information in this article applies to:
This article was previously published under Q208707 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY
This article demonstrates how to include a blank row at the top
of a combo box list. This enables you to set the combo box's LimitToList property to Yes, and still be able to delete the contents of the combo box without triggering the NotInList event.
This feature is created by basing the contents of the combo box on
a union query that adds a null row to the top of the query.
REFERENCESFor more information about union queries, click Microsoft Access Help on the Help menu, type union query in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 6/29/2004 |
---|
Keywords: | kbhowto kbinfo KB208707 |
---|
|