Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can create an additional field in the load script for sorting, and use an expression for sorting like:
avg({1} Sorting_Field)
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?
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?
sort by expression
=num(keepchar (field1,'1234567890' ))
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
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?
uncheck "sort by state"