SharePoint Workspace 2010 Home > Microsoft SharePoint Workspace > Tools > Lists > Creating a custom Lists tool > Creating and editing list views
Office.comPowered by Bing

Modifying view column properties in SharePoint Workspace 2010

To modify view column properties:

  1. Enter the Designer.
  2. Click the list view you want to update.
  3. Click the Columns tab.
  4. Check the fields to be included in the view.
  5. Click the column field you want to update.
  6. Set properties as described in the sections below.
What do you want to do?


Changing column header labels

The initial column header use the name of the referenced form field. If the field name is long, you may want to enter a shorter label for the column label.

  1. Click the field for which you want to edit the column label.
  2. Type a new name in the Header Label text box.

Top of Page Top of Page

Setting the column width

You can allow the Lists tool to set a standard, automatic width, or you can manually set custom column widths, either as a percentage of the total view width, in pixels, or in points.

If all columns are set to Automatic, the width of any column is equal to the full width of the view divided by the number of columns. If one or more columns are set to a specific width, then the width of a column set to Automatic is equal to the remaining measure of the view (after custom-width columns are totaled), divided by the number of remaining columns.

  1. Click the field for which you want to set the column width.
  2. Click the Column width drop-down menu, and then click the setting you want.
  3. If you select Fixed, select the custom measure type you want from the drop-down menu, and then enter a corresponding custom measure.

Top of Page Top of Page

Totaling values for numeric columns

For any field type that uses numeric values, such as Number or Integer, you can enable a column property to total the values in the column and display the total value in the data view.

  1. Click the field for which you want to total values.
  2. Check Total values in this column (numeric columns only).

The example below shows a column that totals values:

A view column that totals values

Setting up a column to show subtotals

You can use grouped sorting to set up a view column to show subtotals and a summary total. The example below shows a view that groups all items according to a "Food Group" field, totals the values for each individual group and calculates the summary total of all groups.

A view with a grouped sort with values totaled

Top of Page Top of Page

Showing a twisty in the column when rows are expandable

This setting applies to views that contain response hierachies. The view must contain at least one form that is set up to create responses to the selected item.

  1. Click the field for which you want to show a twisty when rows are expandable.
  2. Check Show a twisty in this column when row is expandable.

Top of Page Top of Page

Changing the position of columns in the view

You can change the order in which field columns are listed across a view by clicking the navigation buttons in the view design window.

  • To move a field column to the first, or leftmost, position, click Moves field column to first (leftmost) position
  • To move a field column to the last, or rightmost, position, click Moves field column to last (rightmost) position
  • To move a field column up (left), click Moves field column up (left)
  • To move a field column down (right), click Moves field column down (right)

Top of Page Top of Page

Adding or removing field columns

You add or remove field columns in a list by checking or unchecking them in the field list.

  • To check all fields in the list, click Check all fields
  • To uncheck all fields in the list, click Uncheck all fields

 Note   Attachment fields do not appear in this list. However, you can check the Show attachments column option on the Properties tab to add a column to the list view that displays a file attachment icon when an item contains a file attachment.

Top of Page Top of Page

Setting style options

You can set style options for the text that displays in a view column, or in all view columns.

  1. Click the field for which you want to set style options.
  2. Click Select... next to the Font box.
  3. Set the style options you want in the Font dialog box and click OK.

The Font box displays a sample of your selected style options, and the field list shows your selected style options in the Font column.

 Note   The Lists tool does not supporting setting the Strikeout effect to a column.

  1. If you want all view columns to adopt these style options, click Apply to all columns.

Top of Page Top of Page