Can I set search criteria to find records without using wildcard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I dont know it is possible but i have a search box for locating companies and
was wondering is there a way to get records such as 'AA insurance' by only
typing in AA without having to use wildcards.
Also - if there is a way can I please be told it in very simple terms as
have no idea about code.

Cheers
 
I dont know it is possible but i have a search box for locating companies and
was wondering is there a way to get records such as 'AA insurance' by only
typing in AA without having to use wildcards.
Also - if there is a way can I please be told it in very simple terms as
have no idea about code.

Cheers
Click to expand...

is there some deep psychological reason why wildcards are taboo?

If Left([FieldName],2) = "AA" Then

will find AA Insurance, as well as AAA Bail Bonds, etc.

A better solution would be to use a combo box that lists all of the
company names, and use it to locate the correct company.
If you use the combo box wizard to add a new combo to your form,
select the 3rd option on the first page of questions, something like
"Find a record... etc."
 
Instead of using a text box for your search, use a combo box with the Auto
Expand property set to Yes. This is the native behaviour of a combo box.
 
Back
Top