Sort dialog box

Use this dialog box to sort the records in a collection. You can sort the records using selected criteria.

For example, if you wanted to sort the users on the Users form, you might want to sort by users' last names, rather than by their User IDs. This dialog box allows you to do that.

The following table lists the elements of this dialog box and explains their use.

Element Function/Comments
Collection Select the name of the collection you want to sort. If you do not know the name, return to the form and select Help > About This Form to see the name of the current collection.
By Property Select the property (field) by which you want to sort the records.

For example, if you wanted to select a collection of customer records by zip/postal code, in this field, you might select a property known as Zip.

Descending Select this check box to sort the records in reverse alphabetic order.

For example, text-based records are typically sorted in alphabetic order, A-Z. If you select this check box, records will be sorted in reverse alphabetic order, Z-A.

For more information about sort order, see Sorting Collections.

Case-sensitive Select this field to sort records so that records that begin with uppercase letters are listed before records that begin with lowercase letters.

Clear this field to ignore capitalization during the sort.

To display this dialog box, select Edit > Sort Collection.