Can you alphabetize combo box contents?

[Bayou BoB]

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

[fredg]

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.

[David Mitchell]

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