ACC: Empty Row in List Box Can Be Selected (98298)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
This article was previously published under Q98298
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

An empty or null row of a list box can be selected.

CAUSE

Null is a valid selection in Microsoft Access.

STATUS

This behavior is by design.

MORE INFORMATION

It is also possible to select an empty or null value in a combo box.

Steps to Reproduce Behavior


  1. Create a new form.
  2. Create a list box on the form with the following properties: 
          Object: list box
      -------------------------
      RowSourceType: Value List
      RowSource: 1;2;;4
  3. On the View menu, click Form. Note that you can select the empty row between 2 and 4.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbprb KB98298
©2002 Microsoft Corporation. All rights reserved.