ACC: Empty Row in List Box Can Be Selected

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

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