'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Microsoft Access Combo Box AutoExpand Not Working
Question details
Users report that the Microsoft Access combo box stops automatically completing entries when the LimitToList property is disabled and the RowSource uses SELECT DISTINCT.
- Product
- Microsoft Access
- Device & OS
- Windows 11
- Scenario
- Attempting to type into a combo box on an Access form to auto-complete a text entry.
- Observed behavior
- The AutoExpand feature fails to work, requiring the user to manually type the full entry or scroll through the list to select the desired item.
Ensure your Microsoft 365 installation is fully updated, as the Microsoft Access team frequently releases patches for confirmed bugs.
Apply Temporary Form Design Workarounds
Since this is a known Microsoft Access bug on Windows 11, you can adjust your combo box properties temporarily until an official patch is released.
The AutoExpand failure when LimitToList is disabled is an acknowledged bug in recent Microsoft 365 builds on Windows 11. The Access team is actively working on a permanent fix. In the meantime, applying specific form design adjustments can mitigate the issue.
Open your form in Design View, select the affected combo box, open the Property Sheet (F4), navigate to the Data tab, and change 'Limit To List' to 'Yes' if your data entry workflow permits.
If you are using 'SELECT DISTINCT' in your combo box RowSource, try removing the DISTINCT keyword if the underlying data does not contain duplicates, as complex queries are known to trigger this specific AutoExpand issue.
Regularly navigate to File > Account > Update Options > Update Now within Access to check if Microsoft has rolled out the official fix for this Windows 11 combo box bug.
Discover a Free, Lightweight Office Alternative
If you are dealing with ongoing software bugs in your current office suite, consider trying WPS Office for your core productivity tasks. It offers a seamless, highly compatible environment for creating documents, spreadsheets, and presentations without the heavy resource load.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded installer file and follow the quick on-screen instructions.
- 3. Open Your Office Files: Launch WPS Office and directly open your existing Word, Excel, or PowerPoint files seamlessly without losing formatting.
Frequently Asked Questions
What is the AutoExpand property in Microsoft Access?
The AutoExpand property allows a combo box to automatically fill in the rest of a matching text string as the user types, significantly speeding up data entry in forms and reducing typographical errors.
Why does setting LimitToList to 'No' break AutoExpand?
Under normal circumstances, it shouldn't. However, a specific bug in recent Microsoft 365 updates on Windows 11 causes a conflict between the AutoExpand function and LimitToList when set to 'No', specifically when the data source uses a SELECT DISTINCT query.
Will reinstalling Microsoft Access fix this combo box issue?
No, reinstalling will not resolve the issue because it is a known bug within the software's code on Windows 11. You must wait for an official update patch from the Microsoft Access development team.
