O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting Field Contents

Access lets you choose how to display the contents of data in your tables. For example, you can display the field’s contents in all uppercase or lowercase letters, change the color of the text, or display characters in addition to the data entered into the field. For example, if a product is only available by the case, adding the word "cases" after the number would remove any confusion as to the quantity being ordered. Adding formatting instructions only changes how data is displayed—it doesn’t affect the data itself.

Change Field Format

  1. Open a table in Design view.

  2. Click the name of the field to format.

  3. Type the formatting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required