 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / March 2005Combobox control max size
Hi. I'm developing a VBA application, and I have to store into a combbox more of 10.000 records. The problem is that combobox only show 10.000 records, and I'm losing information. There's any property into the combo box to allow to show more tht 10.000 records. Any other idea or suggestion?? Thanks. I suggest you ask yourself this question "How on earth is the user supposed to make a meaningful selection between more than ten thousand options expressed in a simple list?" The answer of course is that the user isn't going to be able to. Therefore, you need to find a way of breaking the list down into more manageable chunks. How you do that depends on your application, but I would recommmend that you divide in terms of some category that is meaningful to the users, so that they will be able to find the item they want in the subjest they expect.  SignatureRegards Jonathan West - Word MVP www.intelligentdocuments.co.uk Please reply to the newsgroup > Hi. > [quoted text clipped - 11 lines] > > Thanks. I think the same as you... but our users says that they don't know the group name of the option they want to select... and they want to be able to select the item from a list with ALL of the items availables. I think we should filter by the parent group, but that is no my decision... Thanks John. > I suggest you ask yourself this question > [quoted text clipped - 23 lines] > > > > Thanks. >I think the same as you... but our users says that they don't know the >group [quoted text clipped - 4 lines] > I think we should filter by the parent group, but that is no my > decision... If the listbox can't manage it, then the design is going to have to change, either to split the list, or to restict it to under 10000. There isn't really a third choice. SignatureRegards Jonathan West - Word MVP www.intelligentdocuments.co.uk Please reply to the newsgroup |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.