Jan 10, 2001 #1 TRYP Programmer Jun 20, 2000 136 US how do i clear a listbox !!!! VBA has no equivelant to listbox.clear does it ???! HELP !! tryp
Jan 10, 2001 #2 dsi Programmer Mar 13, 2000 964 US What application are you referring to? VBA for Office has the Clear method. Code: ListBox1.Clear Upvote 0 Downvote
Jan 10, 2001 Thread starter #3 TRYP Programmer Jun 20, 2000 136 US 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
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"
Jan 10, 2001 #4 dsi Programmer Mar 13, 2000 964 US 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
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.
Jan 15, 2001 #5 cLocKwOrkPRO Programmer Jan 15, 2001 8 US Do While (ListBox1.ListCount >= 1) ListBox1.RemoveItem Loop Pretty basic =) Upvote 0 Downvote