Access Combobox 600 record limit - Visitor Forum


	Back to Visitor Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Combobox 600 record limit

Miguel Ramos

3 years ago

Hi Richard. Miguel from Spain here.

I have a Company table in ACCESS with 630 records through an alphabetically sorted, Company Name column. I search for the records in it through a Combobox that I set following your excellent videos. It works great and the rest of the fields populate perfectly whether I click on the dropdown or type the letters of the name in the Combobox. BUT...

Problem: The Combobox dropdown can't "see" any records after the 600th one. If I write the letters (all of them, when there are two or more records with similar names), they do show up in the Combobox search but the dropdown ignores them even if I type the first letters.

What am I doing wrong? I'm not using my DB as much because I'm bummed by this problem.

Thanks in advance!

	Scott Axton @Reply 3 years ago
Miguel - First Welcome! We need more information on how your combo box is set up. You shouldn't be limited to 600. Which video did you use to make the combo? We probably will need to see screen shots in design mode to help you determine where to proceed. In my db I have close to 30,000 records and it works great.

Miguel Ramos OP @Reply

3 years ago

Hi Scott,

Many thanks for the super fast comment.

Unfortunately, As a visitor I can't upload an image. I can, though, write here the parts you'd need to see.

For example, this is the SELECT I'm using in the Combobox:

SELECT

OrganizacionesT.ORG_FULL,

OrganizacionesT.Estado,

OrganizacionesT.City,

OrganizacionesT.Ad_Agencies,

OrganizacionesT.Ad_Clients,

OrganizacionesT.Category

FROM OrganizacionesT

WHERE

(

( (OrganizacionesT.Estado) Like "*" & [FiltraComunidadBox] & "*"  )

    AND

( (OrganizacionesT.City) Like "*" & [FiltraCityBox] & "*"  )

    AND

( (OrganizacionesT.Ad_Agencies) Like "*" & [FiltraAgenciasBox] & "*" )

    AND

( (OrganizacionesT.Ad_Clients) Like "*" & [FiltraClientesBox] & "*" )

    AND

( (OrganizacionesT.Category) Like "*" & [FiltraCategoriaDrop] & "*" )

);

Explanation: OrganizacionesT is my Company Table and ORG_FULL is the (sorted) text field with the full name of each company.

For the moment, we can ignore all of the WHERE statements. They are filters I set up for various columns.

Is this useful to you?
Thanks!

	Scott Axton @Reply 3 years ago

Scott Axton @Reply

3 years ago

It is best to keep replies together to avoid confusion. As you use the site, you will get to know which buttons take you to what area.
You can become a member for as little as $1.00USD about 1.55ESP. Just go to the courses link above and choose Beginner 2.
Once you are a student you can create an account.

That said, back to your question and your reply.

If you put that SQL statement into a regular query and run it, do you see the correct amount of records?
I have an idea that the filters you are using (the Where Clause ) are limiting the records in a way you don't want for the ComboBox)

	Alex Hedley @Reply 3 years ago
Scott I don't think Visitors can reply yet to messages. Richard is this still on the agenda?

	Scott Axton @Reply 3 years ago
Alex I wasn't sure either. Thus my suggestion to become a student. Just 1$ gets you alot. Maybe add in combining posts too while your making changes?

	Richard Rost @Reply 3 years ago
Miguel: this is a known issue with Access. You do run into a max number of records for combo boxes. I've actually had this on my list for a while to make a TechHelp video about. Stay tuned. Guys: yeah, allowing visitors to reply and post screen shots is on my to do list. I'll get to it... eventually...

Richard Rost @Reply

3 years ago

I just reread your question again and I didn't catch the first time that you're saying it's 600 records. The normal Max for rows in a combo box or list box is 64k records, which is 65,535. You should definitely be able to see way more than 600, so I'm going to guess it's probably a problem with your WHERE condition and all those filters you have. Try removing those and see if the problem goes away. In any case, I do have a video coming up because a few people have asked me about it. They've got 500 or 600,000 records in their database and they're only seeing the first 65,000. So look for a video about that coming up soon. But as far as 600 records, that's definitely an issue with your database.

	Richard Rost @Reply 3 years ago
Oh, and if you would like to reply, sorry that visitors can't reply yet. So, feel free to make a new post, and either Alex or I can stitch them together onto this one.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.

Next Unseen

New Feature: Comment Live View