Suppress Blank Values in List Box

[cbaqir]

How can I suppress blank values in a list box?

[Anonymous · Accepted solution]

use expression in list box and use this expression

if (field <> '',field)

hope it helps

Raj

[MarcoWedel]

If(Len(Trim(Field)),Field)

[vardhancse]

Yes, in list box take expression instead of direct field.

Expression:

if(field<> ' ',field)