Using phrase predict on a combo box on a userform in MS ACCESS ?

Posted on 2008-11-18
Last Modified: 2013-11-28

I have a combo box on a user form that is used to view information on members stored on a database.

This specific combox searches for members based on their last name. I have enabled phrase predict on the box, however, it does not suggest names as I start typing out the name....what could be wrong?

As a result, i must type out the exact last name (more time consuming) ... or look it up in the drop down list.

Thanks in advance!
Question by:Inciteful
    LVL 11

    Expert Comment

    So in the properties of your combo box, "Auto Expand" is set to "Yes"?

    Author Comment

    yes. "auto expand" is set to "Yes".

    Author Comment

    attached is an image of the properties on the box.
    LVL 11

    Assisted Solution

    Two ideas:

    1) Try adding DISTINCT to your rowsource per this link:

    2) Try deleting the combo box and re-creating it.  I've heard that sometimes combo boxes corrupt?
    LVL 74

    Accepted Solution


    The Phase Predict setting has absolutely nothing to do with the combobox auto-completing.
    Before using any property you are unsure about, always press F1 for help.

    Setting the "AutoExpand" property to "Yes" should do this for you (as was already suggested).

    If not, then perhaps you changed other properties that may have affected the normal operation of the combobox.
    (comboboxes as set to "AutoExpand" by default.)

    Try simply re-creating the combobox from scratch *without* changing any other settings.


    Author Closing Comment


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now