About the limit of list box in VBA forms

[magi]

how can i fill a list box with more than 10000 items, if i am not wrong currently we can fill only 10000 items in a list box of ms access form

 

[rewdee]

Why do you want to fill a listbox with 10,000 items. I don't think your users are going to appreciate picking an item from 10000.

Rewdee

 

[magi]

Thanks for your suggestion sir, but what if i use combobox instead for listbox with more than 10000 records in ms access form, how can i fill these records into the combobox.

magi

 

[rewdee]

Sorry Magi but I still think 10,000 records in a combo box is way too many. I think you should rethink the whole structure of the problem and your solution.

Can your items be categorized? By date? By alphabet? By Department? Can you develop relationships? e.g. Instead of creating a listbox or combobox of all inventory items. First have the users select from equipment type, then by equipment subtype and lastly the equipment. So the user may first select Pipe and equipment type, then Hardened Steel and lastly 24 inch. If one doesn't have that kind of narrowing down, you will really cheese off your users as they could be looking through literally thousands of entries.

Hope this helps,
Rewdee

 

[magi]

thankx for your reply, actually my user need to know the description about the inventory, by its number. so i need to put a combbox or listbox in my form.

 

[snoopy75]

Sorry, but I have to agree with Rewdee. Have you ever had to scroll through a listbox or combobox with 10,000 entries? Yuck...

If I understand what you're doing correctly, I think a more user-friendly way would be to have the user type in the item number in a textbox, then have an AfterUpdate event to find and display the correct item description.

If all you want to do is display item numbers and descriptions, use a continuous form instead of a listbox.

--Ryan