Sort problem

[Bear]

I have a slight problem. Well, more of a frustration really.



I have designed a form with a combo box that returns a list of items. When I click on the combo box and the list comes up the list is sorted in ascending order with one strange exception. The list starts with the letter "O" and goes all the way to the letter "Z". Then goes to the letter "A" and continues through to the letter "N". (O, P, ..., Y, Z, A, B, ..., M, N). The field in the table this form is based upon sorts perfectly from "A" to "Z".

Everything else is okay. The list is alphabetized perfectly with this strange exception.

I can use it like it is but, like I said, it is frustrating. Is this a common, inherent problem with Access or have I "screwed" with something and don't know what it is? Has anyone else seen this problem? Can it be corrected?

[June7]

Never seen that happen. There has to be a reason for this. Can you provide the db, or at least an extract of the relevent objects, for analysis?