sorting

[skate]

I think I've seen this question somewhere, but I'm trying to have the items in my combobox sort numberically. The problem is the input values are like L101, L102...so it must be a text. Is there a way to have it sort numerically so I don't get L101, L110, L111, etc.?

 

[Paul_Bricker]

You could add another field to the query underlying your combobox.
NewField:Mid([FieldNameHere],2)

And then sort this field Ascending.
That might do it depending on what the exact values in your Text field are.
Paul