Clear a listbox??? (1 Viewer)

C

chobo321321

Registered User.

Local time

Today, 07:52

Joined

Dec 19, 2004

Messages

53

• Feb 22, 2005

• #1

I'm using access 2003, and for some stupid reason they decided to remove the "clear" method from listboxes... In previous access version I could clear a listbox using "listbox.clear", but now I have no idea. Does anyone know a good way to clear listboxes in Access 2003.

 

W

WayneRyan

AWF VIP

Local time

Today, 15:52

Joined

Nov 19, 2002

Messages

7,122

• Feb 22, 2005

• #2

chobo,

See the DeselectAll button on this demo:

http://www.access-programmers.co.uk/forums/showthread.php?t=81771

Wayne

 

C

chobo321321

Registered User.

Local time

Today, 07:52

Joined

Dec 19, 2004

Messages

53

• Feb 22, 2005

• #3

Thanks for the file. I guess I have to loop through every item in the listbox, and use the removeitem method. I still don't get why the "clear" method was removed from listboxes, and other objects... I fail to see the logic in doing something like that. Anyone care to fill me in on it?

Anyways, thanks for the help, I'll use the looping method to clear me listboxes from now on.

 

W

WayneRyan

AWF VIP

Local time

Today, 15:52

Joined

Nov 19, 2002

Messages

7,122

• Feb 22, 2005

• #4

chobo,

Oh. You want to remove some/all of the rows in your listbox? I thought you
just wanted to Deselect them.

What's the RowSource?

Wayne

 

C

chobo321321

Registered User.

Local time

Today, 07:52

Joined

Dec 19, 2004

Messages

53

• Feb 22, 2005

• #5

I completely forgot about setting the rowsource="". That might do the trick.


** Ya, that works. I was so ticked off the .clear thing didn't work, I forgot all aobut the rowsource God, access can be annoying. Thanks

 

Last edited: Feb 22, 2005