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!
As I recently covered in one of my videos, Access does have a 65,000-row limit. However, if you are having trouble seeing only 600 of them, then you have some kind of other filtering issue with your box.
Love combo boxes and because of your vids I got a perfect score on the course project in my grad elective.
Thanks for the combo box video Richard! Its nice to be reminded, periodically, about the different types.
You bet!
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!
As I recently covered in one of my videos, Access does have a 65,000-row limit. However, if you are having trouble seeing only 600 of them, then you have some kind of other filtering issue with your box.