Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Icon: Flag: (c) Microsoft
Get up to speed
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Ways to customize a form
 

ShowIn Design view

You can customize a form in Design view in the following ways:

Record source Change the tables and queries that a form is based on. For more information, see the topics Change the record source or connection information and Bind a blank form or report to one or more tables or queries.

Controlling and assisting the user You can set form properties to allow or prevent users from adding, deleting, or editing records displayed in a form. You can also add custom Help to a form to assist your users with using the form. For more information, see the following topics:

Form window You can add or remove Maximize and Minimize buttons, short cut menus, and other Form window elements. For more information, see the topic Customize a form or report window.

Sections You can add, remove, hide, or resize the header, footer, and details sections of a form. You can also set section properties to control the appearance and printing of a form. For more information, see these topics:

Controls and subforms You can move, resize, or set the font properties of a control. You can also add controls to display calculated values, totals, current date and time, and other useful information on a form. For more information, see these topics:

ShowIn PivotTable or PivotChart view

You can customize a form in PivotTable or PivotChart view in the following ways:

Add, move, or remove fields    You can add fields to the filter, row, column, and detail areas in PivotTable view, and to the filter, category, series, and data areas in PivotChart view. You can also move fields from one area to another and remove fields from the view. For more information, see the topic Add, move, or remove a field in PivotTable or PivotChart view.

Filter records    You can filter data displayed in the view by adding or moving a field to the filter area. You can also filter a field in the row and column area. For more information, see the topic Create a filter.

Sort records    You can sort items in row or column fields in ascending or descending order. You can also sort items in custom order in PivotTable view. For more information, see the topic Sort records.

Group records    You can group items in row or column fields on intervals, or create custom groups.

Format elements and change captions    In PivotTable view, you can change the font settings, alignment, background color, and number format of a field. You can also change the captions of fields and custom groups. In PivotChart view, you can change the chart type, format data markers, and more. For more information, see the topics Format an element in PivotTable or PivotChart view and Add or change captions, labels, and titles in PivotTable or PivotChart view.

advertisement