• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Working with Tables > Formatting Columns and Rows

Formatting Columns and Rows

The default datasheet Access provides for data entry is compact and functional, but it lacks the little frills that make a datasheet a home. Use the Format menu to change your datasheet's appearance and make it easier to enter and read data in your tables. In this example, we'll show you how to change a column's width to make its contents more legible.

To format columns and rows:

1.
In Datasheet view, open your table and position your cursor over the column selector of the column you want to reformat. Your curosr appears as a black, downward-pointing arrow when it's in position ( Figure 3.11 ).

Figure 3.11. When your cursor is over a column selector it appears as a black, downward-pointing arrow.


2.
Choose Format > Column Width.

The Column Width dialog box appears.

3.
Enter the value for your column's new width in the dialog box and click OK ( Figure 3.12 ).

Figure 3.12. You can assign your columns precise widths by entering the value you want.


The default width (expressed in 1/16ths of an inch) for a column is 15 points. To make your column 2 inches wide, you would type 32 in the dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint