Listbox.clear

sassy2009

Hello All,

i have a listbox control named lstDisplay. I have added items to the list using the additem method. But when i tried clearing the listbox using Clear method i cannot find it. i searched for the listbox control's methods and properties using the object browser but cant find Clear in it. Please help.....Access 2003

Thanks
Sassy2009

MikeTheBike

Hi

Assumning the list Row Source Type is 'Value List' then perhapse

Expand|Select|Wrap|Line Numbers

lstDisplay.RowSource = ""

??

MTB

NeoPa

MTB is on the button with this one.

The opposite of .AddItem though, is .RemoveItem. This enables you to clear a single item from the ListBox.

ADezii

Just as a sidenote, because of the dynamic Re-Indexing of List Box contents after a RemoveItem has been applied, the following code will always remove all entries in a List Box named [lstTest]:

Expand|Select|Wrap|Line Numbers

 Dim intItemsInList As Integer

Dim intCounter As Integer
 
intItemsInList = Me![lstTest].ListCount
 
For intCounter = 0 To intItemsInList - 1

  Me![lstTest].RemoveItem 0

Next

NeoPa

When dealing with a diminishing set (This also applies to rows in Excel where you may delete some within the loop) I always start from the end and work backwards. It makes for easier and more obvious code (not that there is anything wrong with ADezii's code you understand) :

Expand|Select|Wrap|Line Numbers

 Dim intX As Integer
 
With Me.lstTest

  For intX = .ListCount - 1

    Call .RemoveItem(intX)

  Next intX

End With

Listbox.clear

re: Listbox.clear

re: Listbox.clear

re: Listbox.clear

re: Listbox.clear

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about