suppressing nulls

[#1]

Hello,

is there a way to suppress nulls in a List Box?

Thanks!

[#2]

List boxes should supress nulls all on thier own. Are you sure they're nulls? Perhaps your database is being naughty and returning you &nbsp characters or something otherwise equally insidious.

[#3 · Accepted solution]

In listbox in available fields there is <Expression> option. In there you can type expression that suspend empty records. Something like =if(FieldName <>'', FieldName). If after this empty records are still shown then you really may have some "not so empty" values as Ryan sad.