How to stop an oder change in List box

[helen_pip]

Hello Community

I have a list bx which shows the Month of the year and the sort is an expression where the motnhs are displayed in order

match(Outpatient_Referrals.MonthName, 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar')

However when I select Apr from the list box it highlights it and moves it to the end of the list box

What I really want is for when I make a selection from the list box, the order does not change

Any ideas?

Many Thanks

Helen

[#2 · Accepted solution]

Hi,

Right Click on List Box ....Go to the Properties.....& in general tab of list box property

tick or check on Show as a Tree View........ then it will stop move......

Thanks & Regards,

Parag Patil

[helen_pip]

Amazing! Thank you so much

[Gysbert_Wassenaar]

If the option State is set to Ascending or Descending then set it to Auto Ascending.

[hkapadia]

I also had a question about this & did what was suggested here. It worked.

Thanks for the suggestion.