If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Displaying criteria from a combo box
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 -- Steve |
#2
|
|||
|
|||
Displaying criteria from a combo box
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." "Steve" wrote in message ... 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 -- Steve |
#3
|
|||
|
|||
Displaying criteria from a combo box
You mean you want all 25 rows to show at once? Set the ListRow property to
the same value as ListCount. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Steve" wrote in message ... 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 -- Steve |
#4
|
|||
|
|||
Displaying criteria from a combo box
One of the properties of the combo box is List Rows. Set this to 25
"Steve" wrote: 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 -- Steve |
#5
|
|||
|
|||
Displaying criteria from a combo box
On Thu, 11 Feb 2010 07:15:01 -0800, Steve
wrote: 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" featu 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|