Specify default settings for new data access pages

Microsoft Office Access 2003

Show All Show All

Specify default settings for new data access pages

  1. Open a data access page in Design view.
  2. Do one or more of the following:

ShowSet the default connection information

  1. On the Tools menu, click Options, and then click the Pages tab.

  2. Select the Use Default Connection File check box.

  3. In the Default Connection File box, type the name of the connection file that you want to use for all new pages. Or click the Browse button to locate the file.

Note  Setting the ConnectionFile property of the page overrides the default connection file setting.

ShowSet the default indent for sections on grouped pages

  1. On the Tools menu, click Options, and then click the Pages tab.

  2. In the Section Indent box, type the value you want.

Note  Setting the MarginLeft property of a section overrides the default section indent setting. When you add or remove a group level in a page, Microsoft Access uses the default section indent setting to format the sections of all group levels on the page, except those groups for which you explicitly set the MarginLeft property.

ShowSet the default alternate row color for groups

  1. On the Tools menu, click Options, and then click the Pages tab.

  2. In the Alternate Row Color box, type the value you want. Or click the Build button Button image to select the color you want.

Notes

  • Setting the AlternateRowColor property of a group level overrides the default alternate row color setting.

  • When you apply a theme to a page, the alternate row color setting of the group levels in the page is ignored.

ShowSet the default styles for caption and footer sections

  1. On the Tools menu, click Options, and then click the Pages tab.

  2. Do one or both of the following:

    • To specify the style for caption sections, type the settings you want in the Caption Section Style box.

    • To specify the style for footer sections, type the settings you want in the Footer Section Style box.

    For more information about how to specify styles, see Microsoft Internet Explorer Help.

ShowSet the default theme

  1. On the Format menu, click Theme, and then select the theme you want to use in new pages.

  2. Select or clear the check boxes below the list of themes to customize the theme.

  3. Click Set Default.

  4. In the message box that appears, click Yes to confirm.