Microsoft Office Tutorials and References
In Depth Information
Formatting a Datasheet
You can use the Standard Width check box to reset the column width to the
standard or click the Best Fit button to fit the column width to its contents.
Click OK to close the dialog box.
Changing row height
You change row height with the mouse or with the Row Height dialog box.
When you change the height of one row, all the rest of the rows change to
All the rows in a datasheet are the same height; you can’t change the height
of just one.
Changing row height with the mouse is very similar to changing column
width: Move the mouse pointer to the record selector until the pointer turns
into a double-headed arrow (shown in the margin). Then drag up to make
the row shorter)or down to make the row taller.
Alternatively, right-click a record selector and choose Row Height from the
contextual menu to display the Row Height dialog box. Enter the row height
in points. (There are 72 points in an inch.) The Standard Height check box
formats the row at the standard height for the font size you’ve chosen: the
point size of the font plus cushions for the top and the bottom of the row.
Inserting and deleting columns
Columns are fields, so when you insert a column, you’re adding a field, and
when you delete a column, you’re deleting the field and all its data. You can
add and remove fields in Design view, too; see Chapter 2 of this minibook.
To insert a generic field in Datasheet view, follow these steps:
1. Right-click the field name of the column where you want the new, blank
column to appear and choose Insert Field from the contextual menu.
Access adds a column with the name Field1 (or some other number). The
selected columns and all the columns to the right move to make room.
2. Rename the field name by double-clicking the name Access gave it or
by right-clicking it and choosing Rename Column from the contextual
3. Type the new name, and press Enter.
The new field also appears in Design view.
To delete a field and all its data (but think really hard about it first),
rightclick the field name and choose Delete Field from the contextual menu.
When Access asks you to confirm that you want to delete the field and its
data, click the Yes button.