I would like to be able to split the items in a list box over say 4 columns so the user can then make thier multiple selections from it. E.G 100 items, 4 columns of 25.
I have looked through the Forums but haven't found any thing can anyone help Pleassssssse!!!!
Trevor
Why not just use one listbox and allow the user to select multiple items from the one listbox instead of splitting the items equally over X number of listboxes? (i.e. Multiple-Selection Listbox)
The list concerns cattle or sheep movements and a flock of sheep can run into hundreds which would mean a lot of scrolling. the intention is to make it a muliti-select but display a large quantity at a time before scrolling.
Trevor
I don't think you can do this with the native list box control. You can set the number of rows the listbox will display, I think it's the 'List Rows' property...
Ok I have spoken to a friend who also thinks this is not possible so thanks all for your imput and I will have to think of a way of handling large groups of animals.
Well, it's already been mentioned that you can't have multiple column in a listbox. You can have multiple listboxes.
However, in order to do what you are proposing the only way I can think of doing this is to populate each listbox via code (DAO or ADO). this would be quite involved.
Figure how total number records to display
Divide that by number of listboxes (not forgeting to round it). e.g. 50/4 = 12.5 -> 13
Populate 1st listbox with the first 13 records (1-13) , the 2nd with the next 13 records (14-26) , the 3rd with the next 13 records (27-39), and finally the 4th with the remaining 11 records (40-50).
Then once the user selects from the four listboxes, you would then have to figure out a way to use the selected records from each listbox. I assume you need to use them all in the same way and together ar once.
Sounds like too much trouble at least for my taste. But it can be done...
Just because you can do it, doesn't mean you should do it, though.
