Access 2013
Working with Tables
Modifying table appearance
Access offers various ways to modify the appearance of tables, including resizing fields and rows and temporarily hiding information you don't need to see. These changes aren't just about making your table look "pretty"—they also can make the table easier to read.
Resizing fields and rows
If your fields and rows are too small or large for the data contained with them, you can always resize them so all of the text is displayed.
To resize a field:
- Place your cursor over the right gridline in the field title. Your mouse will become a double arrow.
Resizing a field - Click and drag the gridline to the right to increase the field width or to the left to decrease the field width, then release the mouse. The field width will be changed.
The resized field
To resize a row:
- Place your cursor over the bottom gridline in the gray area to the left of the row. Your mouse will become a double arrow.
Resizing a row - Click and drag the gridline downward to increase the row height or upward to decrease the row height, then release the mouse. The row height will be changed.
The resized row
Hiding fields
If you have a field you don't plan on editing or don't want other people to edit, you can hide it. A hidden field is invisible but is still part of your database. Data within a hidden field can still be accessed from forms, queries, reports, and any related tables.
To hide a field:
- Right-click the field title, then select Hide Fields.
Hiding a field - The field will be hidden.
If you decide you would like the field to be visible again, you can unhide it. Simply right-click any field title, then select Unhide Fields. A dialog box will appear. Click the check boxes of any fields you would like to be visible again, then click Close.
Unhiding a hidden field
