Use the ORDER BY clause in the SQL statement; the values will then get
returned alphabetically. Just because the items show in alphabetical order
in Access does not guarantee that they will be returned in that order in a
SQL statement. In fact, by definition, SQL does not guarantee any order
unless it is explicitly expressed. Hence, if you are using

Set rs = db.OpenRecordset("SELECT * FROM Customer")

Change it to:

Set rs = db.OpenRecordset("SELECT * FROM Customer ORDER BY CustomerName")

or such the like. Cheers,

Mark

-----Original Message-----
From: Nigel Spicer [mailto:spicerman@t...]
Sent: 17 November 2001 12:04
To: professional vb
Subject: [pro_vb] How to get combo population to show alphabetically?


I have populated combo1 from a access file, but the list is not showing
alphabetically, but the access file is in alphabetical order. The combobox
does not have a sort property. How do I get combo1 to show the list in
alphabetical order?

Please send me your email so I can reply if I am still having trouble. It
is fast and nicer to make friends on P2P.

Nigel.. spicerman@t...