ACC2000: Overlapping List Box Controls Show Through One Another (197594)

RESOLUTION

You can work around this behavior by setting the Visible property of the underlying list box control(s) to False when not in use. The following example uses a command button to toggle the Visible properties of two list box controls.

1. Start Microsoft Access and open the sample database Northwind.mdb.
2. Create a new form not based on any table or query in Design view. Be sure to add the list box controls in the order listed below so List2 is on top of List0:

      Form: frmListBox
      ------------------------
      Caption: Test List Boxes
   
      List Box:
         Name: List0
         RowSource: Employees
         ColumnCount: 2
         ColumnWidths: .25";1"
         Visible: Yes
         Left: 1"
         Top: .25"
         Width: 1.75"
         Height: 1.3"
      List Box:
         Name: List2
         RowSource: Customers
         ColumnCount: 2
         ColumnWidths: 0";1.25"
         Visible: No
         Left: 1"
         Top: .25"
         Width: 1.75"
         Height: 1.3"
      Command Button:
         Name: Command0
         Caption: Toggle Boxes
         OnClick: [Event Procedure]
   					

3. Set the OnClick property of the command button to the following event procedure:

   Private Sub Command0_Click
      'Toggle the Visible property of each list box
      List0.Visible = Not List0.Visible
      List2.Visible = Not List2.Visible
   End Sub
   					

4. Switch the form to Form view. A list of ID numbers and last names from the Employees table is displayed in the List0 list box.
5. Click the Toggle Boxes button. A list of company names from the Customers table is displayed in the List2 list box.

Note that as you toggle the list boxes and click items inside them, the items in the invisible list box do not appear.