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.

 

[Pat Hartman]

The RowSource is required but you can clear the selected Item.

Me.lstSomeName = Null

The RowSource is the value list. If the Listbox is bound, the instruction above will clear the selected value.

If you are working with a multi-value field, go to jail. Do not pass GO. The multi-value fields are nothing but trouble. Use a properly normalized table with a child table so you can select multiple items. Display it as a subform.

 

[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.

 

[Pat Hartman]

I must be missing something. What is the reason for wanting to remove ALL values from the RowSource? There is no point to a combo or list box if it has no selection options.

You can always replace the RowSource with a query that returns no rows. Is that what you want?

 

[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...