Customize Dropdown List Sort Order

The display order of the items in a dropdown list or listbox can be altered via the ORDER BY step in the Query Wizard.

Step 1:  In the Page Layout Spreadsheet, select a dropdown list control and open the Data Sources tab.

Step 2:  In the Data Sources tab, select the appropriate data source and open the Query Wizard (Edit…).

Step 3:  Go to the ORDER BY step and select the sort order.  For example, the values in the CompanyName field can be arranged according to the City:

Step 4:  Rebuild and run your application.

See Also

Common Formula Examples