When the pointer becomes a double-headed arrow, double-click the edge of the column. To resize a column to best fit its contents, position the pointer on the edge of the column that you want to resize. When the pointer becomes a double-headed arrow, drag the edge of the column until it is the size that you want. Position the pointer on the edge of the column that you want to resize. In addition, you may want to change the height of the rows so that text that does not fit into a column can continue on a new line.Īfter you open a table, query, or form in Datasheet view, you can either manually resize the individual columns or automatically resize a column to fit its contents. Sometimes, not all of the columns in a datasheet will fit on your screen or printout, or individual columns may occupy more space than they need for their contents. This section shows you several ways in which you can accomplish this. You can organize data to make the datasheet easier to view or to display only the required data at a particular time. Organize data by modifying and moving columns or rows When you apply specific formats to rows and columns or add a Total row, a datasheet can also serve as a simple report. In the Navigation Pane, right-click a table or query, and then click Open on the shortcut menu to open the table or query as a datasheet. It displays the fields for each record from a table, form, or query result in a tabular (row and column) format, as shown here.īy default, tables and queries open in Datasheet view.
Organize data by modifying and moving columns or rowsĬhange the gridlines style and background colorĪ datasheet is the visual representation of the data contained in a table, or of the results returned by a query.
You can customize the appearance of a datasheet to display specific data for use as a simple report. Table data or query results that are shown in Datasheet view are commonly referred to as a datasheet. When you open a table or view the results of a query, Access displays the table or query result in Datasheet view.
0 kommentar(er)
