Filter By Form using LIKE clause

[SirPoonga]

Is it possible that when having a user using Filter By Form in a form
that no matter what the user enters in for a value that "LIKE *Value*"
gets automatically replaced? Would I have to do something in the On
Filter or On Apply Filter event?

For example, say I have a form displaying part numbers in datasheet
view. A part number, for example, will look like 123-4567-89-12-1
where each part of the part number means something. Lets say I want to
filter out all the part numbers that contain "4567". In SQL I'd make a
query where the WHERE clasue would contain "partnumber LIKE *4567*".
But if I entered that in witht eh default setup for filter by for it
does something like "partnumber = 4567".

Is there a way to get filter by form to act like that or do I just have
to make my own custom form to handle something like this?

[SirPoonga]

On a related note, can I sort the drop list for each field in filter by
form?

[Bob Quintal]

"SirPoonga" <ke*********@gmail.com> wrote in
news:11*********************@c13g2000cwb.googlegro ups.com:

Is it possible that when having a user using Filter By Form in
a form that no matter what the user enters in for a value that
"LIKE *Value*" gets automatically replaced? Would I have to
do something in the On Filter or On Apply Filter event?

For example, say I have a form displaying part numbers in
datasheet view. A part number, for example, will look like
123-4567-89-12-1 where each part of the part number means
something. Lets say I want to filter out all the part numbers
that contain "4567". In SQL I'd make a query where the WHERE
clasue would contain "partnumber LIKE *4567*". But if I
entered that in witht eh default setup for filter by for it
does something like "partnumber = 4567".

Is there a way to get filter by form to act like that or do I
just have to make my own custom form to handle something like
this?

Just enter *4567* in the control for the partnumber field. It
works fine.
--
Bob Quintal

PA is y I've altered my email address.