Problem with combobox form controls

George_Hepworth 

So you are not a fan of "DOS ain't done till Lotus won't run"?  Sorry.

I was going to construct a simple accdb for you, but it appears as if the bug in Win 11 has been fixed.  Thank you for contributing to this short lived dilemma.

Gene

gjwpromo1weissfincom 

To be clear, I think we don't need to resort to conspiracies to explain anything Microsoft does or doesn't do. 

If you have a sample accdb, running under Access 2016, which exhibits this problem, please share it. I think I can spin up a VM with A2016 on it to check it out.

gjwpromo1weissfincom 

I don't think I said that at all. What I DID say is that Access97 is long out of support. That's not the same as saying Microsoft doesn't care about all of its users. Microsoft has made a lot of regrettable moves over the years, to be sure. Not providing updates to a version of Access now more 26 years old is not one of them, IMO.

That said, the solution for someone who does want to continue to use that software might well be to create a Class to replace some or all of the form and control Class events to provide those features.

You could add "TOP 100" to a SELECT statement in the query which provides records to the combo box to limit the number of records returned, although I'm unsure if that is a universally appropriate cut-off point. 

I'm wrapping up editing on the video from Kent Gorrell's presentation to my User Groups a couple of days ago on that very topic. It primarily focused on interface considerations. However, one of the things that occurred to me during editing was that it is also applicable to data and logic tasks as well. This could be one of those. The video will be available on YouTube in a couple days, if all goes to plan.

If someone needs to maintain Access97 in a production environment, custom code using VBA classes might be an excellent way to help make that happen.

George_Hepworth 

George, I think you hit the nail on the head when you point out that Microsoft doesn't care about all of its users.   

I am wondering if a solution to the problem would be to have the combobox create an event that on the first letter entered (I don't know how to make it exclusive to the first letter only), utilizes a query as its row source  that limits the list of possibilities to 99 using the first letter as starting point.  Unless you have more than 100 entries with a particular letter, that should work.   Is there a way to create a row source limited to a specified number of entries? Again, I just don't know how to work around the "event" occurring with every letter entered. 

George_HepworthThanks, but I believe that Access97 only uses ANSI-87 SQL anyway and cannot use ANSI-92 SQL, so this won't help me.

I remain puzzled how a Windows 11 change in 2022 has caused such a problem for Access 97?

Really hoping for a solution!...

I have now updated my modern Office (2021) with 2312, but the problem persists with Access 97. The problem is a new one, so it is definitely not something that changed inside Access 97, it is something imposed from outside, so I think a fix is reasonable to expect.

Current channel is the latest "normal" version of Office 365 (Click to Run) not the insiders version. And as it is an update for Office, not for Windows, I assume that the problem will persist in Access 97.

What is this 'current channel' and how does a normal Windows 11 user obtain this fix? Will it work for Access 97 (which is affected by this (newish) bug but is of course way outside any type of support warranty)? Thanks for your response.

Once the problem has been solved, I would like to make a final remark, because since I started to suffer from this bug, which in certain contexts has been a serious impediment and has complicated my work a lot, until it has been solved, it has been neither more nor less than a year and a half and honestly it does not seem reasonable to me that Access users are so abandoned....

In any case, thanks to whoever is responsible for the solution. It could have been worse and still not fixed as it happens with other bugs known for years.

I just received version 2312 on the current channel and it certainly seems to be fixed.

Thanks for the interest in this issue.

wove5, thank you.  I have a similar problem on 11, the combobox did not autofill.  After playing with it, I noticed that it did fill if I used a number or the letter a to start.  After reading your post I checked and you are right.  The combobox does not autofill after the 100th or so entry.    I have both 10 and 11 computers and it is only happening on the 11.  When I port into my 11 computer from my 10, the combobox does not work on 11, but does work on the 10.  It is a Win 11 problem. You have isolated the problem, and Microsoft should be able to fix this.  Otherwise, I have to revert to 10.

domoni42 

My apologies. I should have updated this discussion some time ago. My excuse is that finding things on this forum is less than intuitive sometimes.

A fix for this problem is in the works. See this AccessForever article. 

To add my 2c to this, which may help someone with diagnosis. I have just hit the same problem (in the last couple of weeks) using Access 97 (32-bit, of course, and yes I know it is old) on Windows 11 Pro. Combobox autoexpand stopped working, and using the SELECT DISTINCT workaround (suggested above) got it working again but only for the first 100 listed items, after that it fails.

This is a new problem which has suddenly appeared on this machine, it was working fine (under Windows 11) until recently. Still more strangely, the same database still works fine on another Windows 11 machine (also fully updated, as is the first); that is, on that machine the Combobox autoexpansion seems practically unlimited (thousands at any rate).

JF_Ruiz are you using a 32-bit or 64-bit installation of Access/Office? I am following this issue on another forum since autoexpand has worked fine for 25 years and this is frustrating a lot of users who upgraded to Windows 11. 

I have yet to find a common denominator, but it does appear to be worse on 32-bit installations than 64-bit. For now, I would recommend adding the .Dropdown method in an OnChange event. That is a good enough bandaid for me until there is enough information to report this to Microsoft as a bug. 

I have the same problem on Windows 11 and Combo box only autoexpanding first 100 rows in query. Has any progress been made on this? Any workaround? wove5 

wove5 Weird.

I've tried here with Windows 11 and the current Office 365 and, say, item #130 was suggested immeditately at the first keystroke.