Problem with combobox form controls

Occasional Contributor

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.

18 Replies

@José Francisco Ruiz 

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.

I contacted the support chat included with my Microsoft 365 subscription and was told that they didn't know about Access, except for installation and activation issues, and that I had to request assistance by accessing a link that brought me here, so despite knowing the nature of this invaluable forum, I posted thinking that official Access technicians were also here. I am sorry for the misunderstanding.

That said, I greatly appreciate your interest and would be happy to upload my acddb, but at the moment it is unfeasible, as it is a complex and very bulky development that requires going through an online installation and activation process without which it is impossible to start it, so it would be useless.

I would like to point out, in any case, that if the forms works perfectly in Windows 10 and the problem occurs only in windows 11 (I have already tested in two different machines) being something apparently as basic as the population of the text of a combobox while writing in it, it must be because something has changed in the operating system, without Access has adapted to it (I know it sounds strange, but I really can't find another explanation) and that's why I tried to request support, because I am developing with access and VBA for nearly 30 years and normally able to find what is my fault.

In the next days I will continue trying to isolate the problem to prepare and upload a trimmed version that allows to check what I say.

Thanks again.

@José Francisco Ruiz 

 

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

 

 

I do not control all users of my app, so that is not an option. If there is a bug it should be fixed
As I noted, I don't have Windows 11 yet. I'm waiting for a "green light" in the form of seeing experiences of others, like this one, resolved....

That said, I'll try to bring the problem to the attention of someone who might be able to help.
That will be great. I appreciate your help!!!

Meanwhile, I continue debugging myself and find that problematic comboboxes may be only the ones in unbounded forms, with a query as control source. In some other comboxes with form recordset fields behind, all seem to be working as usual. I need to do more checking anyway...
I created a blank new form with a combobox. It has a RowSource (that's probably what you meant when you said ControlSource) that is a query. Is running just fine on Win11 and is doing its normal progressive search.
Neither do I see this issue.
Access Version 2209 (Build 15629.20208 Click to Run) Current channel.
Windows 11 Enterprise 21H2 Build 22000.1098
Thanks @Tom_van_Stiphout & Gustav Brock.

I will try in an empty new form a little later, but really don't understand what can be interfering here. As I say it work in a win10 but don't works in win11 install....
Is there any chance the Access version is also different on the two OSes?

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

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.

Things happen. You could recreate the form, and it will probably work as intended.

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?

@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

They work as intended here.
Access Version 2209 (Build 15629.20208 Click to run) Current channel.
Windows 11 Enterprise 21H2 Build 22000.1098

@Gustav Brock 

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.

Can't tell. AutoComplete is set to Yes for both and both work very well here.