Computer and Business Skills training

Sign Up
Home / Access / Formatting Text

Formatting Text in Microsoft Access


There are several options for formatting your text in the Datasheet.
To change the font face and size using the Ribbon tools, use the following procedure.

  1. Select the text you want to change.
  2. Select the arrow next to the current font name to display the list of available fonts.
  3. Use the scroll bar or the down arrow to scroll down the list of fonts.

Formatting Text

  1. Select the desired font to change the font of text.
  2. With the text still selected, select the arrow next to the current font size to see a list of common font sizes.
  3. Use the scroll bar or the down arrow key to scroll to the size you want and select it. You can also highlight the current font size and type in a new number to indicate the font size you want.

For instructor-led Access classes in Chicago and Los Angeles call us on 888.815.0604.


To select a color for their fonts from the gallery, use the following procedure.

  1. Select the text you want to change.
  2. Select the arrow next to the Font Color tool on the Ribbon to display the gallery. Or select the same tool from the context menu (appears when you select text or by right-clicking).

Choosing a font color from the color picker


  1. Select the color to change the font color.

To review the Colors dialog box, use the following procedure.

  1. Select the text you want to change.
  2. Select the arrow next to the Font Color tool on the Ribbon to display the gallery. Or select the same tool from the context menu (appears when you select text or by right-clicking).
  3. Select More Colors to open the Colors dialog box.


standard colors dialogue box


In the Standard Colors dialog box, simply click on the color and select OK to use that color.

custom colors dialog box


In the Custom Colors dialog box, you can click on the color, or you can enter the red, green, and blue values to get a precise color. When you have the color you want, select OK.

Below are the tools used to add font enhancements.


font enhancements


Finding and Replacing Text

The Find and Replace feature is another one that you may have used in other applications. It’s a nice way to make global changes to your Datasheet.
To find and replace one instance of an item at a time, use the following procedure.

  1. Select Replace from the Find group on the Home tab of the Ribbon.


Access Ribbon


  1. In the Find and Replace dialog box, enter the exact text you want to find in the Find what field.
  2. Enter the replacement text in the Replace with field.

 

Find and Replace

  1. Select an option from the Look In drop down list to indicate whether Access should look in the current field or the current document.
  2. Select an option from the Match drop down list to indicate whether Access should look for any part of the field, the whole field, or the start of the field.
  3. Select an option from the Search drop down list to indicate whether Access should search up, down, or all (the whole datasheet).
  4. Check the Match Case box if applicable.
  5. Check the Search Fields As Formatted box if applicable.
  6. Select Find next to find the next instance of the item.

Access highlights the record where it finds the search term. It also highlights the item from the Find and Replace dialog box.


Replacing Text in Microsoft Access

  1. When Access highlights the item, select Replace to delete the “find” item and paste the “replace” item.
  2. Select Cancel when you have finished.

To Replace all instances of an item, use the following procedure.

  1. Open the Find and Replace dialog box by selecting Replace from the Ribbon.
  2. Enter the exact text you want to find in the Find what field.
  3. Enter the replacement text in the Replace with field.
  4. Select Replace All.


Replace all

 

Access replaces all instances of the item in the current datasheet. Access displays a warning message.


Warning Message

  1. Select Cancel when you have finished.



Related Access Lessons

Introduction to Databases
Basic Tasks in Access


Access student reviews

Every year we train thousands of satisfied students. Read a sample of testimonials at our Microsoft Access training testimonial page.


Access courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every day Book two levels of access training and save $100FREE Class Repeat with each courseBook 3 Level of access Training and save $150