How to make Combo Box display data alphabetically?

[StampMan]

Hi all,
I have an existing combo box on a form that gives me access to 297 different selections. The problem is that as things have been added to the table it sources they have become out of order alphabetically. At the time of creating the combo box, I don't believe the option to display alphabetically was selected. Can I change the properties of this combo box now so it will display the 297 options alphabetically.

If So............ How?
Thanks.

[lfpm062010]

Go to form design, under the combo box property. Under Row Source, change the query to sort.

[StampMan]

Am I looking at the right thing here? There's info already in Row Source???????

[orange]

Look at the property sheet in your graphic- go to that screen-click on the ... at the right hand end of the rowsource - a screen will display the query
add a sort order to the query and save it.

Now your combo data will be sorted (based on your selected sort field and sort order), as mentioned in post#2.

[StampMan]

Thank you :-)