Export (0) Print
Expand All

Modify the columns in a Data View

After you create a Data View, to display different fields from your data source, you can add, remove, or arrange the columns in the existing Data View.

When you add, remove, or arrange the columns in a Data View, you are adding, removing, or arranging the fields as they appear in the Data View. If the Data View displays several fields, each in a different column, you can use the options in the Edit Columns dialog box to add, remove, or move the columns. If the Data View displays the fields in rows, you can use the options in the Edit Columns dialog box to add, remove, or move the rows.

NoteNote

The Edit Columns command is available only when you are working with a Data View that displays data in an HTML table.

You can also use the table editing commands on the Table menu to modify the columns in a Data View.

To add columns

  1. In Design view, right-click the Data View, and then click Show Common Control Tasks.

  2. In the Common Data View Tasks list, click Edit Columns.

    NoteNote

    The Edit Columns command is not available if the Data View is in an HTML table that uses rowspan or colspan attributes with a value greater than 1.

  3. In the Edit Columns dialog box, under Available fields, click the field that you want to include in the Data View, and then click Add. Repeat for each field that you want to add.

    tip noteTip

    To select multiple fields at one time, press and hold CTRL while you click the fields.

    NoteNote

    If you have changed the column headers in the Data View, the column headers, not the field names, are displayed in the Displayed Columns list.

To remove columns

  1. In Design view, right-click the Data View, and then click Show Common Control Tasks.

  2. In the Common Data View Tasks list, click Edit Columns.

  3. In the Edit Columns dialog box, under Displayed Columns, click the field that you want to remove from the Data View, and then click Remove. Repeat for each field that you want to remove.

    tip noteTip

    To select multiple fields at one time, press and hold CTRL while you click the fields.

To arrange columns

  1. In Design view, click the Data View to select it.

  2. On the Data View menu, click Edit Columns.

  3. In the Edit Columns dialog box, under Displayed columns, click the field that you want to move in the Data View, and then click Move Up or Move Down. Repeat for each field that you want to move.

    NoteNote

    Moving a field up in the list moves the column to the left in the Data View. Moving a field down in the list moves the column to the right.

See also

Send feedback about this topic to Microsoft. © 2011 Microsoft Corporation. All rights reserved.

Community Additions

ADD
Show:
© 2014 Microsoft