Results 1 to 2 of 2
  1. #1
    TOPSie is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    108

    Windows 11 Access combo boxes don't autocomplete

    Just updated to a new Windows 11 PC and ported in my Access 2016 apps.
    One app has a form with 2 combo boxes each linked to their own table of values.
    On WIndows 10 both these boxes would autocomplete so if you typed "ab" the box would find the first entry in the table starting with these letters and suggest the first value it found "Aberdeen" (say)

    One Windows 11 the first box behaved the same way - but the second never suggested anything (not quite true - but read on)

    It appears that if there are less than~100 entries in the table then Auto complete works, but if there are more than 100 entries then it doesn't .


    Really annoying and was almost on the point of going back to Windows 10 when I stumbled on a perfect solution.

    Code:
    Private Sub cboLocation_Enter()
    cboLocation.Dropdown
    
    End Sub
    and as soon as you tab or click on the box, the list drops down and Autocomplete works :-)

    Hope this helps

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-06-2016, 09:25 PM
  2. Replies: 5
    Last Post: 02-04-2015, 07:53 PM
  3. Combo Box Autocomplete / Filter as you type
    By Pimped in forum Programming
    Replies: 28
    Last Post: 01-14-2015, 08:37 AM
  4. Replies: 4
    Last Post: 01-08-2012, 01:57 PM
  5. Combo-Box Filter/Autocomplete Question
    By jhcarrell in forum Forms
    Replies: 4
    Last Post: 11-02-2010, 12:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums