The DataWindow painter provides six views related to the DataWindow object you are working on.

Design view  Shows a representation of the DataWindow object and its controls. You use this view to design the layout and appearance of the DataWindow object.

Preview view  Shows the DataWindow object with data as it will appear at execution time. If the Print Preview toggle is selected, you see the DataWindow object as it would appear when printed.

Properties view  Displays the property sheet for the currently selected control(s) in the DataWindow object, for the currently selected band in the DataWindow object, or for the DataWindow object itself. You can view and change the values of properties in this view.

Control List view  Lists all controls in the DataWindow object. Selecting controls in this view selects them in Design view too. You can also sort controls by Control Name or Tag.

Data view  Replaces the Data Retained On Save dialog box; it displays the data that can be used to populate a DataWindow object. Unlike the dialog box, changes made to the data are shown in the other views when focus changes. Undo is supported for this view.

Column Specifications view  Replaces functions previously handled in the Column Specification, Prompt For Criteria, and Modify Result Set dialog boxes.

The view shows a list of the columns in the data source. For the columns, you can add, modify, and delete initial values, validation expressions, and validation messages. You can also specify that you want a column to be included in a prompt for retrieval criteria during data retrieval. To add a column to the DataWindow object, you can drag and drop the column from the Column Specification view to Design view.

For external or stored procedure data sources, you can add, delete, and edit columns (column name, type, and length).