List box sorting

[#1]

I have a list box containing the values in the following format:

My  1st book

My  3rd book

My  2nd book

But i want to show my values in the listbox as:

My 1st book

My 2nd book

My 3rd book

I have tried all the sorting combination under the properties. I have created an expression for this listbox instead of using a field in the listbox.

[cesaraccardi]

You can create an additional field in the load script for sorting, and use an expression for sorting like:

avg({1} Sorting_Field)

[swuehl]

You probably already tried the Text sort option, this worked out for me, so I probably miss something essential in your setting. Could you post a small sample file?

[#4]

i have tried every combination in the sorting tab and one more thing, my list is multi coloumn. Please anyone suggest something. should i try sorting by expression? if yes, then what expression should i write?

[#5 · Accepted solution]

sort by expression

=num(keepchar (field1,'1234567890' ))

[swuehl]

Maybe uncheck 'order by column' option in presentation tab? Can't reproduce your issue here.

Well, it's really hard to tell, you should at least post a screenshot and your expressions used, at best a small sample app.

Using QV11.

Regards,

Stefan

[#7]

Many thanks for the reply Pari, It worked for me. Can you Please tell me how to stop the self adjusting nature of list box, which is:

when you select a value in the list box, it goes tot he top or bottom.

Could you please help me on this?

[#8]

uncheck "sort by state"