AnyPart SEARCH using setfilter !!

pskannaa

Hi,

I like to search record on the customer List, hav added one textbox for getting search charactor, while typing the charactor i want to get the approp. records on list.

Search Customer: CEMENT
while typing the search text it shd be match 'anypart' of word on customer list.
Eg: result is like below
ABC CEMENT LTD,
CEMENT GLOBAL LTD,
SUPER BRAND CEMENT LTD, etc..


Question:
1. how to filter 'ANYPART' string using setfilter(eg above) ??
2. how to get the resulted List while typing ??

Thanks,

Psk

idiot

1. Setfilter: *CEMENT*
2. Click Find Next

pskannaa

I put the code on 'Ok' button on 'CUSTOMER LIST' form.

placed Textbox and button(eg below)...

Search : TEXTBOX
OK(button)

once i typed the char and click Ok button , but there is no effect. it's showing blank.

code: (OK button)
Rec.SETFILTER(Rec.Name,'*%1',txtSearch,'*');

anything missing !!!

pskannaa

I hav got the solution,

Rec.SETFILTER(Rec.Name,'%1','*' + txtSearch + '*');


one doubt, if anyone know plz reply...

Is't possible to MARK the Color for Only Matching charactor on the LIST ???

like our FORUM....