Microsoft Office Tutorials and References
In Depth Information
Formatting a Datasheet
Add & Delete group on the Fields tab of the Ribbon; choose Rich Text from
the drop-down menu, and rename the field. Then you can enter your fancy
text in the field.
After you create a Rich Text field, view your data in a datasheet or (even
better) on a form and then format away. When you select text in a Rich Text
field, a formatting bar pops up with buttons for all the common formatting
options. All the formatting options on the Home tab of the Ribbon are
available to you. To format text, first select the text you want to format and then
select the type of formatting you want to apply.
A Rich Text field can be displayed on a form or report in a text box control.
The text box has a Text Format property that must be set to Rich Text
for the text to appear onscreen with its formatting.
Changing gridlines and background color
Gridlines are the gray horizontal and vertical lines that separate cells in a
datasheet. You can change the color of the gridlines or choose not to display
them at all. You can even choose a special gridline effect other than plain lines.
Access 2013 has a sneaky button that you can click to display the Datasheet
Formatting dialog box, shown in Figure 1-16. This button is in the bottom-right
corner of the Text Formatting group on the Home tab of the Ribbon. (If you look
at the Ribbon, you see a few more of these sneaky buttons that open a dialog
box to let you work with all the settings in the Ribbon group.) If you hover the
mouse over that button, you see that it’s called Datasheet Formatting.