Show only certain listbox values

[#1]

If I have a listbox with 10 values and I only want to show 6 of them that are handpicked.  How should I do that?

[swuehl · Accepted solution]

On general tab of your list box properties, select <expression> from the field list and enter:

=if(match(FIELD,'A','B','C','D','E','F'), FIELD)

where FIELD is your field name and A, B, C... are your handpicked values.

Hope this helps,

Stefan

[#3]

That worked.  Can I make one of them defaulted?

[swuehl]

You mean a default selection?

You can select your value, then select 'set clear state' from the selections menu or maybe create a trigger with action select in field (e.g. on open document event) to achieve something like this.

[#5]

HI,

If you want to select one particular value always.

Try this,

1. Select one value in the listbox

2. Go to the properties

3. Enable the option 'Always One Selected Value'

4. Apply and then OK.

I welcome all your feedback.