Why is record in combobox not alphabetically arranged? 2

Hi Mandy,

The combo/listbox has no load event. Please reread the code I provided in thread thread184-1824310

hth

MarK

Sorting by collation sequence MACHINE is the usuual sorting, unless you defined special collations for fields. It sorts English okay, may only fail on some special characters with diacritics or umlauts, for example. Most likely, you also get Names starting with lowercase letters after names starting with uppercase letters, as 'a' has a byte value of 97 while 'Z' has 90. So all lowercase letter are sorted after all uppercase letters, too, even when you only use the English/Latin 26 letters without any accents, etc.

Chriss

Just to follow up Chris's reply, you might need to issue a SET COLLATE command immediately before the SELECT. For example, if you have Spanish names in the table, and the names might include characters such as Ñ or any accented letter, then you should do [tt]SET COLLATE TO "SPANISH"[/tt].

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

Thank you Mike, Chris, Mj for always helping.. God bless....

Ok I'll Try putting collate... Thanks again...