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 | From the drop-down list, select the name of the collection you want to sort. If you do not know the name, return to the form and click About This Form on the Help menu to see the name of the current collection. |
| By Property | From the drop-down list, 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 | To sort the records in the reverse order to what is considered
normal, select this check box.
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 | When selected, records are sorted so that records that begin
with uppercase letters display records that begin with lowercase
letters.
When cleared, the sorting routine ignores capitalization. For example, suppose you have three records for customers, whose business names are Electronic Commerce, Ltd., eMall, Inc., and Endzone. If you select this check box, they would be sorted as follows (in normal, ascending, order):
If you clear this check box, they would be sorted as follows:
|
From the Edit menu, select Sort Collection.