How do you clear a listbox?

[Deleted member 73419]

Hi,

I've a listbox on a form which is populated with the RecordSet of a DAO query.

I want to clear the contents of the listbox but have been unsuccessful with the following.

listbox.clear

'Method or data member not found'.

listbox.RowSource = ""
or
listbox.RowSource = vbNullString

Does nothing, all the records are still in the listbox.

For i = 0 To listbox.ListCount - 1
  listbox.RemoveItem 0
Next

'The RowSourceType property must be set to Value List to use this method'

Does anyone have any other ideas?

Thanks

 

[theDBguy]

What exactly do you mean by "clearing" the listbox? Are you saying you want a blank listbox or just unselect all the items?

 

[Deleted member 73419]

What exactly do you mean by "clearing" the listbox? Are you saying you want a blank listbox or just unselect all the items?

I'd like to clear the listbox.

 

[theDBguy]

I'd like to clear the listbox.

That was my question. What do you mean by "clear" the listbox? Make it empty or no selected items?

 

[cheekybuddha]

theDBguy said:
What exactly do you mean by "clearing" the listbox? Are you saying you want a blank listbox or just unselect all the items?

I'd like to clear the listbox.

From your original description, you may want:

which is populated with the RecordSet of a DAO query

Set Me.listbox.Recordset = Nothing

 

[arnelgp]

just make the listbox "unbound"

Me.listbox.RowSource = ""

 

[cheekybuddha]

just make the listbox "unbound"

Me.listbox.RowSource = ""

The OP said they tried that and it didn't work.

 

[arnelgp]

The OP said they tried that and it didn't work.

try it first and forget the op, maybe it is Not what he meant.

 

[Gasman]

PMFJI,
What does listbox.Clear do ?

At first I thought the O/P had just made the name up , but it does exist.
However I cannot find it mentioned at https://learn.microsoft.com/en-us/office/vba/api/access.listbox

I would say however that this worked for me?

Private Sub List5_DblClick(Cancel As Integer)
Me.List5.RowSource = ""
End Sub

 

[cheekybuddha]

try it first and forget the op, maybe it is Not what he meant.

My Windows is not working at the moment so couldn't test.

I just wondered whether when you you do Set Me.listbox.Recordset = rs, then perhaps the RowSource is still vbNullstring and you have to set its Recorsdet = Nothing to clear it?

 

[moke123]

At first I thought the O/P had just made the name up , but it does exist.

I see it in reference to Excel and other office apps, but not Access.

 

[Gasman]

It comes up if you start to type it in Access though?

 

[moke123]

It comes up if you start to type it in Access though?

Not for me. Didn't check with excel.

 

[Gasman]

Yes, I only have 2007, but I entered it, intellisense made it propercase. My understanding is if it was not recognised, it would remain lowercase as I entered it?

In hospital car park atm, so cannot make any further tests.

 

[jdraw]

If you add a button to your form(via Google):

How to Clear Items from Listbox – iAccessWorld.com

Private Sub cmdClearList_Click()
Dim i As Integer
For i = lstFileLocation.ListCount - 1 To 0 Step -1
    lstFileLocation.RemoveItem (i)
Next i
End Sub

 

[Gasman]

OK, just got home and tried again.
Whilst Clear does not appear in the dropdown, it changes from lowercase to propercase?

That is what confused me.

You will have to take my word for it, that I did not change the second pic manually.

 

[MajP]

@Gasman. If "clear" is a method of some other object I believe intellisense will change the capitalization even if not a property or method of the current combobox object.

 

[Deleted member 73419]

Hi,
For clarity, by clear I am meaning that I want to empty the listbox of any previous results - I want a blank listbox.

Set lstResults.Recordset = Nothing

Also doesn't do anything. Bit strange really as all the previous results are still in the listbox even though the recordset is nothing you may have expected it to have cleared out its contents...

 

[Gasman]

Not recordset, rowsource !

 

[Deleted member 73419]

Also, for reference, this is not a multiselect listbox (not sure whether this matters though as I'm not looking to clear the selected entries but clear the entire listbox of everything!!)