About customizing Datasheet view in FrontPage

You can make changes to a Datasheet view from the Edit Datasheet View page. The Edit Datasheet View page lets you make basic changes to the view, such as specify a different name for the view, change column settings, change the sort order and filter criteria, and so on.

If you want to further customize your page, open the view in Microsoft Office FrontPage 2003. FrontPage offers you advanced options to customize the appearance and layout of a view. In addition to the choices offered by the Edit Datasheet View page, you can do the following:

• Add images to the page
• Apply themes to the page
• Edit the text contained in the page
• Customize the view toolbar

When a view is opened in FrontPage, it appears disabled and does not support any interactions. You cannot make changes to the data in the view, refresh the view, or make structural changes, such as add or delete a column.

FrontPage views

You can use one of the three FrontPage views to customize a Datasheet view: Design, Preview, or Code. Each view offers unique functionality, and makes it easier for you to design a view that suits your needs.

Design view    When you click the Edit with Microsoft FrontPage button on the Standard Buttons toolbar in Internet Explorer, the view opens in FrontPage Design view.

To customize a Datasheet view, the list must be opened in Datasheet view prior to clicking the Edit button. Note that if you open a list in Standard view, then click the Edit in Datasheet button on the view toolbar prior to clicking the Edit button on the browser, the Standard view will open in FrontPage.

In Design view, you make changes to the view. When you make a change, FrontPage updates the view. For example, when you specify a filter criteria, FrontPage applies the new criteria and refreshes the view.

Preview    When you switch to Preview, you can preview the changes you have made to the view, and see how the view and the page containing the view will look in Internet Explorer. The list cannot connect to the server, so only limited functionality is available in this view.

Code view    If you want to make changes to the view programmatically, switch to Code view. In this view, you can add or modify code contained in the page. When you switch from Code view to Design view, FrontPage will attempt to refresh the view. If the code has one or more errors, FrontPage will notify you of the same.

Ways to customize a view in FrontPage

Change column settings    You can specify the columns that should be included in the view, and the column order.

Change sort order    You can include multiple columns in the sort order. You can specify the order of the fields, and for each field, the sort direction. For example, you can sort the view in ascending order of the Last Name column, and within each last name, sort the rows in descending order of the Designation column.

Change filter settings    You can specify a simple filter condition, such as Last Name equals Smith, or specify a complex filter criteria that includes multiple filter clauses and the AND and OR operators.

Change Total row settings    You can show or hide the Total row in the Datasheet view. Note that you will not be able to change the aggregate function that is used to calculate the total for each column.

Change the view You can change the type of view from Datasheet view to Standard view or Calendar view.

Customize the view toolbar    You can choose a full toolbar or a summary toolbar. Based on the view type, the full toolbar displays all applicable buttons. A summary toolbar will display the name of the list and the button to add a new item, row, or document.

Customize the page containing the view    You can add or edit text surrounding the view, add images, change the page’s background color, and add or change themes. For more information on how to customize a page, see FrontPage Help.