Oct 16 2022 03:12 AM - edited Oct 24 2022 02:32 AM
I'm using exactly the same accdb in two computers. One is Win10 the other has been updated (fresh install) to Win11.
In the win10 computer, form's Combobox controls are working as they should, narrowing and presenting possible values as you type in it.
But in Win11 most of the times that doesn't work and I type without getting any hint from the list.
If I expand down the Combobox, the list is filled, so it is not a problem with the control source, and results matching what is already write are there.
This is a really big problem and make very, very difficult to work, so I ask you please to check the problem as soon as possible.
Oct 16 2022 03:46 PM
While this is, indeed, a frustrating situation, I'm sure, you're probably not reaching the right audience with your request to "check the problem". That's because forums like this are NOT staffed by Microsoft support people. Rather, almost all of the participants are Access developers who share their experience and knowledge as peers. We have no control over what Microsoft does, or does not do. We can recommend and request, of course.
That said, it sounds like there might be some problem with Windows 11 on your computer. Replicating that problem is the first step to getting help. Can you upload a copy of an accdb exhibiting this problem? I don't have Windows 11 installed, but perhaps someone else who does have it already could examine it for you and eventually offer ideas about dealing with the problem.
Oct 17 2022 12:16 AM
Oct 17 2022 05:30 AM
Window 11 has been a problem with Access, the best you can do is to have both machines use window 10. I had a similar issue as wello
Oct 17 2022 05:36 AM
Oct 17 2022 06:39 AM
Oct 17 2022 06:49 AM
Oct 17 2022 07:01 AM
Oct 17 2022 07:10 AM
Oct 17 2022 07:20 AM
Oct 17 2022 11:18 AM
Oct 20 2022 12:16 AM
I'm back from a trip and checking...
Both computers have the same Access Version: 2009 Build 15629.20208 CTR Current Chanel.
Now, I will try to reproduce problem in a newly created db
Oct 20 2022 12:40 AM - edited Oct 20 2022 12:43 AM
Oct 20 2022 12:40 AM - edited Oct 20 2022 12:43 AM
In a clean database, with a new form and not so complex control row source it works as usual.
The question now is why in my original db it works only in W10 but not on W11?
But I understand that is mainly my problem...
I'm sorry to have take your time.
Thanks again.
Oct 20 2022 12:44 AM
Oct 20 2022 04:50 AM
May someone please have a look into this db? I'm really out of clues...
It is a newly created one, like the two tables, the stored query, and the only form.
In the form I have inserted two Comboboxes. The first works as it should and gets target value as you type, the second doesn't do that in Windows 11 system (where I design the db) but it works perfectly in a Windows 10 system.
I have try in another computer with windows 11 / Microsoft 365 installed, and problem is there too
Is there any explanation for that?
Oct 24 2022 02:21 AM - edited Oct 24 2022 02:22 AM
Oct 24 2022 02:21 AM - edited Oct 24 2022 02:22 AM
@Gustav Brock @George Hepworth @Tom_van_Stiphout
Wondering why I didn't get any comment about the database I thought I had included with my last message, as it is clear to me that it at least confirms an Access / Windows 11 interaction error, I entered the thread of my question and saw that in fact the accdb was not uploaded because of a file compatibility problem*.
So I'm re-uploading it in a zip file in the hope that someone can give me a clue.
*the attachment's database1.accdb content type (application/octet-stream) does not match its file extension and has been removed
Oct 24 2022 02:34 AM
Oct 24 2022 02:46 AM
I have tried in two different windows 11 / Ms 365 installs, both fully updated, and the 2nd combobox does not work in none of them, while it does in Windows 10.
Data is in the list, but doesn't get to the field while I type in it...
Now I'm completely out of my depth...
Thanks for your interest and collaboration.
Oct 24 2022 02:53 AM
Jul 04 2023 04:14 AM
Hi @Gustav Brock ,
I have experienced a similar problem with the MS Access combobox on Win 11, however, my problem is that the auto-expand feature stops working beyond the 100th row. So if the initial text that I type is the start of any one of the first 100 values of the bound column, then auto-expand works fine, however, when typing the initial text of the values for rows 101 and beyond, I get no auto-expand result.
Our respective experiences seem to indicate a possible difference between Win 10 & Win 11 for the MS Access combobox. I have been putting up with this problem for about a year and a half, after I changed from Win 10 to Win 11. I had tried searching the web for a solution a few times since encountering the issue, however, it never occurred to me that the underlying issue could be the difference between Win 11 & Win 10. I'm sorry that I do not have any solution to offer for this apparent issue with the MS Access combobox on Win 11, however, I thought it was worth posting a reply in support of your issue because this is a very a similar issue for me too.
FYI, the row sources of my bound columns are queries of tables, and the columns being bound to are of type text. I have 3 combo boxes that are affected: two with 261 rows in the rowsource, and one other with around 10,400 rows for the row source; and hence I hit my problem of this apparent "100 row" limit on auto-expand.
Regards,
David.
Jan 03 2024 07:25 AM
SolutionA fix for this problem is in the works. See this AccessForever article.