MS Access Dropdown List Not Finding All Options

[bobbly]

I am working on a Page that will reference data from a query. My query shows all of the companies I work with, about 1800 in total. I am creating a page where the user can select the customer from a dropdown list and see some demographic info about them. I created the page using the Wizard and it seems to work fine except for one thing. The Group Filter Control I set up to select the Customer from the list of 1800 is only displaying the first 250 or so values... it goes from letter A to midway through letter C then the list just stops.

Is this due to a hard limit of how many values can be found in a dropdown list? And if so, is there another way to achieve the same thing?

Thanks, will appreciate your help.

[Jim Doherty]

I am working on a Page that will reference data from a query. My query shows all of the companies I work with, about 1800 in total. I am creating a page where the user can select the customer from a dropdown list and see some demographic info about them. I created the page using the Wizard and it seems to work fine except for one thing. The Group Filter Control I set up to select the Customer from the list of 1800 is only displaying the first 250 or so values... it goes from letter A to midway through letter C then the list just stops.

Is this due to a hard limit of how many values can be found in a dropdown list? And if so, is there another way to achieve the same thing?

Thanks, will appreciate your help.

You are better off storing values for a combo dropdown or Listbox in a table. Value Lists are ok for the small stuff, that in the main you do not believe needs editing or manipulating and yes there is a limit to the amount of characters that can be added to a value list.

Using tables instead to store the lookup data is a better strategy, it gives you a more flexibile and easier capability to manipulate the data ie:sort,search, add edit and so on