Alphabatize Combo Box

[ArmySGT via AccessMonster.com]

Hello again,

How can I alphabatize a combo box so when you see the data it is in
alphabatical order?

For example,

The combo box shows the below data:
Superman, Dave
Wonderwoman, Girl
Invisible, Man

I want it to read:

Invisible, Man
Superman, Dave
Wonderwoman, Girl

Thanks again!

 

[BruceM]

If the row source is a value list, arrange it in whatever order you like.
If it is a named query or a statement that begins with SELECT, click the
three dots to the left of the Row Source property on the property sheet and
select Ascending for the sort order in the desired field or fields.

 

[fredg]

Hello again,

How can I alphabatize a combo box so when you see the data it is in
alphabatical order?

For example,

The combo box shows the below data:
Superman, Dave
Wonderwoman, Girl
Invisible, Man

I want it to read:

Invisible, Man
Superman, Dave
Wonderwoman, Girl

Thanks again!

Create a query that returns all the fields you need.
Sort this query on the name field (Ascending).
Make this query the Rowsource for the combo box.