ListCount being weird

[Alex]

I have a listbox, whose rowsource I set during the forms On Current event.

The problem is when I open the form, on acFormAdd, the listcount property of
the listbox shows up as 1. This is of course false, since the listbox is
empty. Does anyone know why this is happening?

Thanks!

Alex Brown

 

[Dirk Goldgar]

I have a listbox, whose rowsource I set during the forms On Current event.

The problem is when I open the form, on acFormAdd, the listcount property
of
the listbox shows up as 1. This is of course false, since the listbox is
empty. Does anyone know why this is happening?

Thanks!

Alex Brown

Does your list box have its Column Heads property set to Yes/True? If so,
the row of column headers will count toward the ListCount.

 

[Alex]

No, the column heads are specifically set to false. (Although this is
default). In John's reply I put in my code. Thanks!

Alex Brown