List Box Has Too Many Items to Display On Screen

[lenlab]

My database form has a listbox with one column that contains 52 items. Because of computer screen size limitations I can only show about 2/3's of the items even with the lowest font setting of 8. I want to be able to display all 52 values for the User. Right now the User has to scroll down the list. Not an ideal way to process the form's list box.



Is there a way to make the list box wrap the data around or display the field in 2 columns so all 52 items can be seen on the form?

I have searched the forum for this kind of question and could not find it asked by anyone.

[June7]

Basically, no. That's why listbox has a scroll bar.

Even if you could get them to display, the second column would not be selectable items. Each row represents a single item.

Scrolling is not required. Typing first letter of an item will go to first use of that letter, type same letter again will go to next use, etc.

I don't use listboxes for very long lists. I use comboboxes to take advantage of AutoExpand property.

[lenlab]

Thank you for responding and suggestions.

My listbox has 52 dates so keying in the first letter of an item is not an option. If I have to key in more numbers I might as well scroll down. I was looking for a way to display all the dates....ie having the column wrap around. It seems like a limitation that the info in a listbox being displayed is limited by the size of your monitor. AS the developer I have to be concerned that the USER has a smaller monitor than I have and hence I have to be careful how the listbox is displayed. There should be an option for changing how the listbox is displayed to eliminate the need to scroll.

I guess I have to live with this. I was hoping someone knew another way to deal with this other than scrolling.

[June7]

I would use a combobox.