I have implemented a search-as-you-type function on a combobox on a form displaying company details, so that a user can can start typing an organisation's name and get a drop down of matches, from which they can pick the one they want, and that organisations details are displayed.
That works. No problem.
But only as long as the user types in the organisation name in the order of the words in the record.
As an example:
The field contains "University of Cambridge"
If the user types "uni" the list of matches will include "University of Cambridge"
If the user types "camb" the list of matches will also include "University of Cambridge"
But if the user types "Uni Cambridge" or "Cambridge Uni" then it is not matched.
Is it possible in Access to create a query to produce matches for the criteria input by the user in any order, or is that something that's only possible in full-scale SQL server?
That works. No problem.
But only as long as the user types in the organisation name in the order of the words in the record.
As an example:
The field contains "University of Cambridge"
If the user types "uni" the list of matches will include "University of Cambridge"
If the user types "camb" the list of matches will also include "University of Cambridge"
But if the user types "Uni Cambridge" or "Cambridge Uni" then it is not matched.
Is it possible in Access to create a query to produce matches for the criteria input by the user in any order, or is that something that's only possible in full-scale SQL server?