Re: [MSAccessProfessionals] Combo Box

hi Bill,

here's an article about the bug on accessforever.org dated Nov 25

https://www.accessforever.org/post/combo-box-auto-expand-may-not-work-correctly-in-windows-11

kind regards,
crystal

On 12/15/2023 4:59 PM, Bill Singer wrote:

Paco,

Is there a solution yet?

 

Bill

 

Bill Singer

 

Bill.Singer@at-group.net

 

 

 

From: MSAccessProfessionals@groups.io On Behalf Of paco@cellarinfo.com
Sent: Friday, December 15, 2023 4:02 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Combo Box

 

This is a known bug related (I think) to Windows 11. It has happened to some, but not all, of my combo boxes.

 

Paco

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, December 15, 2023 2:29 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Combo Box

 

I have a combo box on a form that looks up my customers.

 

As I type, the combo box sorts the names and when I finally get the correct name I hit enter and the form move to the correct record…

 

Until today.  Now when I type the combo box does nothing most of the time.  When I type into the box it does not sort…with the exception of very few customers that have names that start with letters that are in the early part of the alphabet.

If I click the drop down button and type in the box, it sort correctly and will select the correct record. 

 

I have deleted and re-created the combo box multiple times.  Each time it acts the same.

I have even gone copied a combo box off of an old form that worked correctly, and it still acts the same. 

 

I even pulled a complete form from an old backup database and the Combo box still does not work.

 

The event is a Embedded Macro in AFTER UPDATE

Here is the Row Source  ..   SELECT [q_MainCustomerInput].[OrganizationName], [q_MainCustomerInput].[CustomersID] FROM q_MainCustomerInput;

 

Any thoughts?

 

Bill

 

Bill Singer

Bill.Singer@at-group.net