Filter Sort Wild Card?

[MX1]

Hi all,

I have a form with a dropdown field on it that is a concatenation of
LastName, FirstName and Middle Initial. For example, John A Brown shows up
as "Brown, John A." I'm tring to filter on this field to show me specific
records. However, it seems as though I have to type in the whole value for
it to find the record I'm looking for due to the concatenation. I was
hoping I could set this field to auto-fill in when I filter on it. For
example, I right click field and select filter sort. As soon as I start
typing B R O, it would come up with Brown, John A. If that is not possible,
is there some sort of wildcard I can use in my filter so it picks up the
value without me typing the whole concatenated value - (e.g Brow*, or
Brow%). I've tried lots of possible wildcards but none work.

Thanks in advance!

[MX1]

Duh, got it...

"MX1" <mx*@mx1.abc> wrote in message
news:t_DDb.570102$Fm2.534891@attbi_s04...

Hi all,

I have a form with a dropdown field on it that is a concatenation of
LastName, FirstName and Middle Initial. For example, John A Brown shows up as "Brown, John A." I'm tring to filter on this field to show me specific
records. However, it seems as though I have to type in the whole value for it to find the record I'm looking for due to the concatenation. I was
hoping I could set this field to auto-fill in when I filter on it. For
example, I right click field and select filter sort. As soon as I start
typing B R O, it would come up with Brown, John A. If that is not possible, is there some sort of wildcard I can use in my filter so it picks up the
value without me typing the whole concatenated value - (e.g Brow*, or
Brow%). I've tried lots of possible wildcards but none work.

Thanks in advance!