• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1242
  • Last Modified:

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

Expert,

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!
0
Inciteful
Asked:
Inciteful
  • 3
  • 2
2 Solutions
 
SeanStricklandCommented:
So in the properties of your combo box, "Auto Expand" is set to "Yes"?
0
 
IncitefulAuthor Commented:
yes. "auto expand" is set to "Yes".
0
 
IncitefulAuthor Commented:
attached is an image of the properties on the box.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
SeanStricklandCommented:
Two ideas:

1) Try adding DISTINCT to your rowsource per this link: http://support.microsoft.com/kb/824189

2) Try deleting the combo box and re-creating it.  I've heard that sometimes combo boxes corrupt?
0
 
Jeffrey CoachmanCommented:
Inciteful,

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.

JeffCoachman
0
 
IncitefulAuthor Commented:
thanks!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now