Displaying criteria from a combo box

[Steve]

Hello,

I have a combo box that has about 25 items listed in it. On the form, when
i click the drop down box, I am trying to get it to display all the items
versus having to scroll down through them. Does anybody know how to make
this happen??

Thanks

 

[Al Campagna]

Steve,
Adjust the List Rows properties of the combo to 25 (or more)
If List Rows = 30, and you only have 25, only 25 rows show.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Douglas J. Steele]

You mean you want all 25 rows to show at once? Set the ListRow property to
the same value as ListCount.

 

[RonaldoOneNil]

One of the properties of the combo box is List Rows. Set this to 25

 

[John W. Vinson]

Hello,

I have a combo box that has about 25 items listed in it. On the form, when
i click the drop down box, I am trying to get it to display all the items
versus having to scroll down through them. Does anybody know how to make
this happen??

Thanks

You've gotten advice about the ListRows property but... a couple of ideas:

- You know that a Listbox control is always 'dropped down' and can be sized to
show all the rows all the time?
- What will you want to do when the combo needs to expand to 215 rows? Bigger
monitors and/or smaller fonts? <g>
- A Combo Box has an "autocomplete" feature: if you tab into it and type a
letter, it will jump to the first row starting with that letter; a second
letter will find the first row starting with those two letters. This can make
using the mouse or scrolling unnecessary.