Thanks twinnyfo, that seems to have done the trick. Your expertise is much appreciated.

BTW, I suspect that it was the same problem that the OP had. Unfortunately there was a mention of a combobox, which I suspect had nothing to do with the problem. Have a great day!

I had a similar problem sorting people's names stored as FullName. The SQL was simple without a combo box (SELECT tblResumes.Full Name
FROM tblResumes ORDER BY tblResumes.Full Name;). To fix the problem I created a new column in the table, named it StaffName and copied all of the names into it. The same SQL construct worked with StaffName.

My guess is that the table is corrupt because out of about 2000 tables in this database...