Fuzzy Search?

[Mark Watlock]

The feature that allows you type the first part of a
field entry and have Access display that entire entry
does not seem to be working. Is there a setting that we
need to correct to make this wor?k. Will be glad to
offer more info if you need it. Using Access XP.

 

[Lynn Trapp]

How are you trying to do this?

 

[Guest]

Thank you for your quick response.
This came up in an Access class that I am teaching. I
think the values are the result of a lookup column that
displays values from another table. Does this help?

 

[Lynn Trapp]

It helps a little bit. First of all, you will find that most everyone here
will advise you to not use the Lookup wizard feature at the table level.
Rather, you should use a ComboBox on a form to do that kind of lookup. The
ComboBox will do what you are looking for.