how do I sort items in a drop down combo box

[slateman]

This is a simple request. how do I make a dropdown list
display in alphabetical order. It should do it anyway.

 

[Rick Brandt]

This is a simple request. how do I make a dropdown list display in
alphabetical order. It should do it anyway.

If you are using a table as a RowSource change to a SELECT query against
the same table and set a sort order in the query.

If you are using a ValueList you have no choice but to enter the values
in the order you want them displayed.

 

[John W. Vinson]

This is a simple request. how do I make a dropdown list
display in alphabetical order. It should do it anyway.

What is the RowSourceType of the combo? And what is the RowSource?

The most common technique is to have a Table containing the values for the
combo box; but rather than basing the combo directly on the (unsorted) Table,
base it on a Query sorting the records in the desired order.

 

[David W. Fenton]

What is the RowSourceType of the combo? And what is the RowSource?

The most common technique is to have a Table containing the values
for the combo box; but rather than basing the combo directly on
the (unsorted) Table, base it on a Query sorting the records in
the desired order.

The advantage there (besides the sorting) is that you don't have to
edit the form to change the dropdown list -- you just add a record
to the source table.