Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Use Field List To Arrange Fields In. For more information see Field Arrangement on a FastTab. To see the PivotTable Field List.
Moving a field using cut-paste. The position of the field within the record the length of the field the format of the data in the field and the sequence into which the field is to be sorted. If you want to sort by a field but do not want the field displayed in your datasheet results add the field to the grid choose Ascending or Descending from the Sort row but then uncheck the Show checkbox.
To use the Field List in Access first open a form in design view.
3 Choose Ascending or Descending from the Sort row drop down list for each field. In the command bar select Cut. In-place is fastest and most memory efficient but no good if you want to also retain the old list. Select another element to paste the cut element relative to.