A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Displaying criteria from a combo box



 
 
Thread Tools Display Modes
  #1  
Old February 11th, 2010, 04:15 PM posted to microsoft.public.access.forms
Steve
external usenet poster
 
Posts: 2,662
Default 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  
Old February 11th, 2010, 04:37 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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  
Old February 11th, 2010, 04:41 PM posted to microsoft.public.access.forms
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default 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  
Old February 11th, 2010, 04:44 PM posted to microsoft.public.access.forms
RonaldoOneNil
external usenet poster
 
Posts: 345
Default 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  
Old February 11th, 2010, 07:37 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.