List Box Sort by expression with excluded item at the bottom

[#1]

I need to sort a list box in alphabetical order, but the available items (white items) need to be listed at the top (A-Z) and the excluded items (grayed-out items) need to be listed at the bottom (A-Z).  How would I do this?

[Luis_Cortizo · Accepted solution]

I'm not sure if have understood the question, that's the default sort behavior of a list box (white on top grey at bottom).

Check that you are using this configuration on the Sort tab:

[maxgro]

in sort tab

state      ascending

text        A-->Z

or I'm missing something?

[#4]

You guys are absolutely correct, I didn't have State Ascending selected.

Curious, what is the difference between Auto Ascending and Ascending?

[Luis_Cortizo]

Auto ascending sort the list box only if it has a vertical scroll bar otherwise it doesn't do anything.

You can test it with a list box of let's say... ten values, show on screen only five with the vertical scroll bar and then, re-size the listbox to show every value (it stops sorting)