ACC: Empty Row in List Box Can Be Selected

ID: Q98298

The information in this article applies to:

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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. 



Keywords          : FmsCmbo 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: March 23, 1999