List Box Alphabetically

[CarrieFisher]

Good Afternoon Everyone,

Could you please tell me if there is a easy way to make it alphabetically?

I am using access 2010, and VERY junior in access.

Thank you,

Carrie

 

[wrmosca]

Carrie

I assume there is a query or table for the Listbox's RowSource. You can see the RowSource property if you open the form in design view, click on the Properties icon and then find the RowSource property.

When you find the RowSource click on that line and you will see a little builder box (...). Click on that to open the query.

With a query, you just open it in design view and put "ascending" in the sort line.

If it is a table clicking the builder box will ask you if you want to make a query. Click yes (or OK...I can't remember which one shows up) and do the sorting in the query as I said above.