By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,798 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

Can you alphabetize combo box contents?

P: n/a
Hi!

Currently my combo box contents are not in alphabetical order, and I'm
wondering if there is a way to make the contents appear in
alphabetical order when you open the combo box. How would you do this?
Many thanks!

Kevin
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 15 Jan 2004 03:56:06 GMT, Bayou BoB <ca*******@hotmail.com>
wrote:
Hi!

Currently my combo box contents are not in alphabetical order, and I'm
wondering if there is a way to make the contents appear in
alphabetical order when you open the combo box. How would you do this?
Many thanks!

Kevin


Kevin,
Make a query or an SQL statement the Rowsource of the Combo Box.
If you use a query, sort the query by the field wanted.

If you make an SQL the rowsource, add
Order By [Somefield];
at the end.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
Nov 12 '05 #2

P: n/a
Bayou BoB <ca*******@hotmail.com> wrote in message news:<9k********************************@4ax.com>. ..
Hi!

Currently my combo box contents are not in alphabetical order, and I'm
wondering if there is a way to make the contents appear in
alphabetical order when you open the combo box. How would you do this?
Many thanks!

Kevin


Base the combobox on a query and sort ascending on the text field.

David
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.