How to clear up listbox in VBA 6.5

[AccessFreak]

I tried.

listbox1.clear

But it does not work

Can someone help.. thanks

 

[CameronM]

I assume you have a List Box control with a source set to 'Value List'. If you do, then you can iterate through the items and remove them.

While ListBox1.ListCount > 0
ListBox1.RemoveItem (0)
Wend

Or you can simply set the Row Source to a null string.

Me.List4.RowSource = ""