How to filter the data values in a list box?

[rabbani_sk]

Hi all, my query is i need to filter some of the data values from a list box.

for example , i hav a field ,

Product code

A xx

A

Byy

B

Cz

C

D xx

E xx

So, i need to filter only the data values which consists of 'XX' eg.(A xx, D xx, E xx) , do you any idea , which function to use to filter the data value..?

[Gysbert_Wassenaar]

Type *xx in the search box of the listbox. If you want the listbox to never show the other values then use an expression instead of the field name for the listbox: =if(wildmatch([Product code],'*xx'), [Product code]).

edit: try this =if(wildmatch([Product code],'*xx'),null(),[Product code])

[rabbani_sk]

Hi,

Thanks for your reply Gysbert , but my question is not to show the  product code with 'XX',

[johnca · Accepted solution]

Try this...

=If(WildMatch([Product Code],'*xx'),Null(),[Product Code])

Note the close parens after the '*xx'.

--john

[rabbani_sk]

Thank you gysbert

[rabbani_sk]

Hi john,

its working,

Thanks for your reply

[johnca]

Gysbert deserves some credit too. All I did was find the syntax error in his solution.

John

[paulyeo11]

hi john

i unable to find any diff between yr and gysbert. it is wild match , the w and m need big cap ?

[johnca]

Gysbert edited his initial response, and it is now correct too. His initial solution was correct except he forgot a close parenthesis. I saw that and added it. I capitalize words in functions to better see them, that's all. Both are identical in effect and either solution works the same.

[#10]

Nice one guys.. Helpful