Microsoft Office Tutorials and References
In Depth Information
Designing Table Appearance
Designing Table Appearance
By default, when you create a table, the
fields appear in the order you created them
and they are all the same general width,
regardless of the field type or size.
Mouse pointer
Changing Table Field Width
On some tables, you may find fields that aren’t
wide enough to display the information they
contain such as an address field. Other fields are too
wide and are wasting precious screen space,
perhaps a State field. You can easily adjust the table
field column width, however, changing the table
field width does not affect the allowable number
of characters in the field. It only changes how you
see the table.
Figure 19-1
Changing field width.
Click the Save button on the Quick Access Toolbar.
If you forget to click the Save button, when you
close the table, Access asks you if you want to save
your changes. Click Yes if you want to save them,
or No if you don’t.
In Access, you can change a table field width the
same way you can in Excel. Position your mouse
pointer over the right side of the field name, along
the gray bar. When the mouse is in the correct
position, it changes into a black double arrow with
a bar through it. (See Figure 19-1.)
Formatting Tables
In Access, you began with a blank datasheet and
then added your data. But in its generic form, a
table can sometimes be difficult to read. Perhaps
the fonts are too small, or the data doesn’t line up
in a way that makes it easy to read. In fact, a
datasheet is just plain boring.
Drag the gray bar to the right to make the field
column wider or drag it to the left to make it
narrower. As you drag the mouse a black line running
down the screen indicates the new field width.
Search JabSto ::

Custom Search