How do I hide values in a list box?

[Anonymous]

I would like to hide values in a list box.  For example, I have a list box with values - red, blue, yellow, green, purple, I want to hide the value green from appearing in the list box.  Is this possible?

Thanks

Greg

[senpradip007]

Try like

If(Value <> 'Green', Value)

or

If(not WildMatch(Value , 'Green'),Value )

[jsingh71 · Accepted solution]

Hi Greg,

You will  writeexpression in list box like

     if(<FieldName> <> 'red', <FieldName>)

Find Example in attachment.

--Jai

[Anonymous]

Thanks Jai

How do I hide more than one colour?

[jsingh71]

then you need to use match or wildmatch function.

--Jai

[Anonymous]

Thanks Jai

Would you be able to show me an example of the match or wildcard function please?

Thanks very much.

Greg

[jsingh71]

Find attachment.

--Jai

[Anonymous]

Very grateful.  Thanks very much Jai.

Greg