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


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!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

So in the properties of your combo box, "Auto Expand" is set to "Yes"?
IncitefulAuthor Commented:
yes. "auto expand" is set to "Yes".
IncitefulAuthor Commented:
attached is an image of the properties on the box.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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?
Jeffrey CoachmanMIS LiasonCommented:

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IncitefulAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.