Exclude Option from a ListBox

[sspringer]

If I have a field/listbox with 5 unique options, and I want to exclude showing one of them (not necessarily a null, just a value I don't want to provide as a filter option) - what is the easiest way to do that?

[swuehl · Accepted solution]

Select <expression> from the field drop down list in the list box properties and enter

=if(FIELD <> 'DontWantThisValue', FIELD)