Automatic Unselect an item in a List Box

[Anonymous]

Hello!  how do I automatic unslect  3items  by using wildmatch function (NON*) in a list box?  I tried going to sheet properties and added action select excluded..It works but when i clear all my selections , the select excluded doesnt function anymore.  I was thinking of doing the action select in field but just don't know to compose the formula for wildmatch.

Tks.

[vgutkovsky]

You need 2 actions. First you need to do a Select in Field of the values that you DON'T want. Then you need a Select Excluded below that first action.

Regards,

Vlad

[Anonymous]

Vlad,

The excluded items were grayed out but the values I expectected is wrong.

Tks.

[vgutkovsky]

Please post (1) the field name and (2) the values you are selecting in the Select in Field action.

Vlad