List Box without certain fields

[knightwriter]

Hi All,

I have a list box with 10 fields and I only want to show 5 of them. I have used the expression to remove one field before by using

=if([Car Colour] <> 'Blue', [Car Colour])

But when I use it the same expression for more than once nothing happens and the list of colours remain the same. Any suggestions?

=if([Car Colour] <> 'Blue', [Car Colour],

if([Car Colour] <> 'Red', [Car Colour],

if([Car Colour] <> 'Yella', [Car Colour],

if([Car Colour] <> 'Pink', [Car Colour],

if([Car Colour] <> 'Grey', [Car Colour],)))))

[Anonymous · Accepted solution]

after the first condition the Car Colour will be displayed if it is not blue,

do you want that None of the colours match Car Colour will be used?

try this:

if (match[Car Colour],'Blue'.'Red','Yella','Pink','Grey')=0, [Car Colour],null())

[maximiliano_vel]

Perhaps this is what you looking for?

[knightwriter]

Great stuff, thank you.