empty listbox

[PeterM]

I have a listbox on a form which contains up to 50 items. It gets
repopulated many times. Currently I'm using .RemoveItem to empty the listbox
and then populate it with .AddItem which is time consuming.

I tried setting the listbox .Value to Null which didn't work. Is there a
more efficient way to empty the listbox?

Any help would be appreciated!

 

[Dirk Goldgar]

I have a listbox on a form which contains up to 50 items. It gets
repopulated many times. Currently I'm using .RemoveItem to empty the
listbox and then populate it with .AddItem which is time consuming.

I tried setting the listbox .Value to Null which didn't work. Is
there a more efficient way to empty the listbox?

Any help would be appreciated!

Have you tried just setting its RowSource property to an empty string ;
e.g.,

Me!lstMyListBox.RowSource = ""

?