Multi value listt box unsorted

[hnorgaar]

Hi there



I have a form which can choose different car brands, then model and engine. Thats all good. Now I also get different engines with different horse power and need to choose several of them. Thats working too, but the values from the multi value list stored in my multi field chosen like 75HK, 90HK, 100HK, 145HK, but the result in the multi box field comes out unsorted like everything under 100(HK) last like this 100HK, 145HK, 75HK, 90HK. Can I sort them somehow?
Thx for any input

Henrik

[June7]

This is alpha sort rules, one character at a time. 1 comes before 7. If you want 75HK before 100HK then need to use placeholder zeros. 075HK will sort before 100HK.

Are letters "HK" always included? Why save those?

[moke123]

You may also be able to add a field to your query, removing the letters with val() and converting to numeric with Clng() so it sorts properly.
something like Clng(val(YourFieldName))

[mike60smart]

Hi Henrik

Can you upload a copy of your database?

[hnorgaar]

Thx guys, found a VBA to update the sorting in the field