What expression to use to put one specific value on bottom of a list box

[rudywelvaert]

Hi,

In a list box I have following values based on Field CODE in a table CODES:

I want the list box be sorted in such a way that the value Nihil is the last value:

In the Sort tab of the Properties of the list box I use the following Expression:

=If(CODE='Nihil', '1', '0') & CODE

but nothing changes.

Thanks

R.W.

[sunny_talwar · Accepted solution]

Try this

[rudywelvaert]

Thanks Sunny,

This works

R.W.