Results 1 to 2 of 2

Thread: Combo Box List - Suggestion as I type (not just beginning matches)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2016
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Combo Box List - Suggestion as I type (not just beginning matches)

    Hello,

    I'm relatively new to access so thank you for providing any insight you can.

    I have a Combo box in a Form that lists a bunch of names. I have the source of this dropdown pulling from a table called 'names'. When a user clicks the dropdown in the Form and then begins typing - it naturally will narrow the population showing to names that begin with whatever the user typed. Is it possible to have the list narrow the population showing to include other matches within the names not just the beginning?

    Example: a user types "Jo" ... It would currently show "John Smith" as an option but it would not show "Sam Jones" as an option because it doesn't start with "Jo".

    Thanks for any advice!
    Mr R.

  2. #2
    Board Regular
    Join Date
    May 2013
    Posts
    655
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combo Box List - Suggestion as I type (not just beginning matches)

    A quick Google brings this up.?

    https://www.tek-tips.com/viewthread.cfm?qid=1756368
    Office 2007
    Access novice. Sometimes trying to give something back

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •