Hide Null Values inside List Box ?

[#1]

Hi;

I would like to hide null values inside list box ?

I researched for properties and functions but i did not find any thing what i can use !!

Please help me...

Thanks in advance

[sparur · Accepted solution]

in ListBox null values suppress automatically. but may be you have empty string or something else... so you can use expression in listbox:

if (Len(YourField) > 0, YourField)

[#3]

Thank you...

I try it in list box properties, layout, show condition. But it did not work ?

I get datas from oracle DB and in the database some fields are ampty so i dont want to see any fields which are empty...

This is my main problem ???

Thanks in advance

[sparur]

Why "Show Condition"?

Open properties of your ListBox, on General tab you should to change option "Field" from your YourField into Expression (on top of drop down list) and paste my expression

[sparur]

or you can remove such data (with empty field) in the script.

[#6]

Ok. Sorry...

Its my mistake.

It works correctly thanks again...

[sateeshkumar]

Ya it works fine for not showing null values. but i used this list box field in set analysis to fix the value in text box. so that value is changing by selecting items list box. I need to fix the value in text box with any changes to in list box field.  can anyone help to me to get this.

[LearnFreak]

Hi,

I have the same issue, but in my case I have a Multibox and when I use this solution nothing changes.

Do you have any other idea for Multibox?