Combo Box Limitation

  • Thread starter Thread starter Luc McCutcheon
  • Start date Start date
L

Luc McCutcheon

Hi

I have a form with a combo box in Access 2000. The form is
create on a Store Proc of SQL 2000 and the combo box use
to select a valid product. Now we have more than 10 000
products in the table where the combo box looking for the
product. So when we try to select the product over the row
10 000 we are not able to see them.

I have no limit record in my form but I don't know where
I'm able to fix it for the combo box.

Hope I'm clear.

Thanks for your help.

It really appreciate.

Luc
 
There is a limit to what the combo box will show, but I'm not sure if 10,000
is it or not. However, when you start getting this many items, it is
sometimes easier to "pre-filter" the items in the combo box with another
combo box or textbox. For example, have only items starting with the letter
A or items from a particular category in the combo box. You will find an
example of doing this here.

http://www.mvps.org/access/forms/frm0028.htm
 
I copied this from a post in 2003 by somebody identifying
himself as Wayne Morgan: "By default, Access sets a limit
of 1000 rows for lists. You can overcome this by choosing
Tools|Options and selecting the Edit/Find tab and
modifying this figure in the 'Don't display lists......'
box."
Also, see http://support.microsoft.com/?id=209595

(ACC2000: How to Synchronize Two Combo Boxes on a Form)
 
Maximum total rows that a combo box or list box can show is 65,536. If the
row source returns more rows that this number, the additional rows will not
show.
 
Thanks for the help.

Luc
-----Original Message-----
There is a limit to what the combo box will show, but I'm not sure if 10,000
is it or not. However, when you start getting this many items, it is
sometimes easier to "pre-filter" the items in the combo box with another
combo box or textbox. For example, have only items starting with the letter
A or items from a particular category in the combo box. You will find an
example of doing this here.

http://www.mvps.org/access/forms/frm0028.htm

--
Wayne Morgan
Microsoft Access MVP





.
Click to expand...
 
Bruce,

I don't remember sending the message you mentioned, but don't remember not
sending it either. If you picked it up in comp.databases.ms-access, there
has been a person there trying to spoof several posters.

The 1000 list items you mention are the items in a "Filter by Form" list.
When you go to "filter by form", Access creates combo boxes on each field
for you to choose filter options. These combo boxes will be limited to the
1000 items in their drop down lists.
 
Back
Top