Use of Wildcard in String Expression

[NEWER USER]

I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.

InStr([Enter Food Product(s)],[Food Group])

Criteria is >0

Instead of typing Milk,Butter,Bread,Lettuce when prompted in the Parameter
Value

I would like to be able to type Mi, Bu,Br,Le. Can this be accomplished?

 

[Jerry Whittle]

In the

In the criteria for the proper field:

Like "*" & [Enter Food Product] & "*"

The above will find BU anywhere in the string. If you want it to start with
BU:

Like [Enter Food Product] & "*"

 

[John Spencer]

Since INSTR does not use wildcards I don't see how your question applies.

You might be able to use something like the following if you wanted to match
on just two characters.

InStr([Enter Food Product(s)], Left([Food Group],2))



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[NEWER USER]

That works for well for searching one value. What if I want to return Milk
or Bread ? I get an empty string when doing so. This is why I was using
InStr and separating values with a comma (milk,bread). My users may not
spell correctly so I wanted a wildcard to minimize/avoid spelling errors.
Any other suggestions with wildcard and InStr function?

In the

In the criteria for the proper field:

Like "*" & [Enter Food Product] & "*"

The above will find BU anywhere in the string. If you want it to start with
BU:

Like [Enter Food Product] & "*"
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.

InStr([Enter Food Product(s)],[Food Group])

Criteria is >0

Instead of typing Milk,Butter,Bread,Lettuce when prompted in the Parameter
Value

I would like to be able to type Mi, Bu,Br,Le. Can this be accomplished?

 

[NEWER USER]

You answered my question. No wildcards allowed in INSTR

Since INSTR does not use wildcards I don't see how your question applies.

You might be able to use something like the following if you wanted to match
on just two characters.

InStr([Enter Food Product(s)], Left([Food Group],2))



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.

InStr([Enter Food Product(s)],[Food Group])

Criteria is >0

Instead of typing Milk,Butter,Bread,Lettuce when prompted in the Parameter
Value

I would like to be able to type Mi, Bu,Br,Le. Can this be accomplished?

.