Move a column (MDB)

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

 Important   Changing the field order in table or query Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.) can affect combo boxes or list boxes that are based on that table or query. If your table or query is the record source for a combo box or list box, consider moving the field in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).

ShowMove a column in Datasheet view

  1. Open a table, query, form, view, or stored procedure in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).
  2. Select the columns you want to move.

To select one column, click the field selector (field selector: A small box or bar that you click to select an entire column in a datasheet.) for that column.

A table in Datasheet view

To select adjacent columns, click a column field selector and then, without releasing the mouse button, drag to extend the selection.

  1. Click and hold down the mouse button in the field selectors again.
  2. Drag the columns to a new position.

 Note   If the columns don't move, they may be frozen, and you may have to unfreeze them.

ShowMove a field in table Design view

Changing field order in table Design view changes the order in which fields are stored in the table and also changes the column order in the table's datasheet (datasheet: Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.).

  1. Open a table in Design view.
  2. Select the fields you want to move.

To select one field, click that field's row selector (row selector: A small box or bar that, when clicked, selects an entire row in table or macro Design view, or when you sort and group records in report Design view.).

To select a group of fields, drag through the row selectors of those fields.

A table in Design view

Callout 1 Row selectors

  1. Click and hold down the mouse button in the row selector again. Microsoft Access displays a thin horizontal bar just above the last selected row.
  2. Drag the horizontal bar to the row just below where you want to move the fields.

ShowMove a field in the design grid in a query or advanced filter

 
 
Applies to:
Access 2003