How Can I remove certain Items from a List Box

[#1]

I don't want to show particular data in a list box.

I have tried this but not working for me.

in the expression pane

if(ListBoxfield='D',Null(),ListboxField)

what it does for me is:

A     A

B     B

C     C

D     -

what I want is :

A

B

C

Please Help.

Regards,

Gaurav Tyagi

[tresB]

Try:

if(ListBoxfield<>'D',ListboxField)

[#3]

Still the same result, No change.

I'm writing it in the second tab i.e. Expression Pane is it the place where I have to write it?

[tresB · Accepted solution]

No. See the screenshot:

[#5]

TAKE ONE LIST BOX

AND GOTO LIST BOX PROPERTY AND IN THE EXPRESSION TYPE THE BELOW CODE(

=IF(OrderNo <>'D', OrderNo) 

CHECK THE SCREEN SHOT (ATTACHED).

[suniljain]

You can use following expression

if(Len(ListBoxfield)>1,ListboxField)

[#7]

I didn't scroldown that much before have too many fields in the table

Thanks