Listbox ListCount issue

[Dennis]

I have a listbox that I manually populate. I've reached the limit of how many
entries I can have (about 540) in the listbox, and get an error (property too
long). Okay, well and good. So to clean up, I do a series of "removeitem"
commands. However, the LISTCOUNT is not getting reset to 0. So that when I
try to repopulate the listbox, I immediately generate the error again.

This aoppears to be happeneing even if I close and reopen the application.

What do I need to do in order to cleanly remove the items?

(Access 2002)

Thanks!

 

[Douglas J Steele]

Rather than using removeitem, try setting the row source to a null string:

Me!MyListBox.RowSource = vbNullString

 

[Jeff Boyce]

Dennis

You've described "how" (manually populating a listbox) you are trying to
solve an issue. What's the issue? There may be other ways to get done what
you need to...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dennis]

Issue resolved. I'd saved the form after the list had been populated.

Dennis