Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

argggg

Status
Not open for further replies.
TRYP

TRYP

Programmer
Joined
Jun 20, 2000
Messages
136
Location
US
how do i clear a listbox !!!!
VBA has no equivelant to listbox.clear does it ???!
HELP !!

tryp
 
Sort by date Sort by votes
What application are you referring to? VBA for Office has the Clear method.
Code: 
ListBox1.Clear
 
Upvote 0 Downvote
MS access 97 and 2000
(some clients are on 97 some on 2000)

it gives me an error message when i do
listBox.clear

"object does not support this action"
 
Upvote 0 Downvote
Check out the Help for the ListBox object. It looks as though the Clear method will not work if it is bound to a data source.
 
Upvote 0 Downvote
Do While (ListBox1.ListCount >= 1)
ListBox1.RemoveItem
Loop

Pretty basic =)
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top