Try the Access Course for Free!

The Format Property for Yes/No Fields in Access – Tutorial

/ / Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013
The Format Property for Yes/No Fields in Access - Tutorial: A picture of a user setting the

The Format Property for Yes/No Fields in Access: Overview

            You can set the Format property for Yes/No fields in Access to change the way that they will display in forms and reports. The following formats are available for logical fields in Access. To set the Format property for Yes/No fields in Access, simply select the logical field in the table design grid. Then click into the “Format” property in the field properties section and select a choice from the drop-down menu available.

Name: Logical “True” Value:
True/False True
Yes/No Yes
On/Off On

The Format Property for Yes/No Fields in Access - Tutorial: A picture of a user setting the "Format" property for a "Yes/No" field in Access 2013.

The Format Property for Yes/No Fields in Access – Tutorial: A picture of a user setting the “Format” property for a “Yes/No” field in Access 2013.

The Format Property for Yes/No Fields in Access: Instructions

  1. Select the table to open in “Design View” from the Navigation Pane.
  2. Press “Ctrl” + “Enter” on your keyboard to open the table in design view.
  3. Select the field in the design grid whose properties you want to set.
  4. In the “Field Properties” section at the bottom of the window, select the “General” tab.
  5. Click into the “Format” field property box and click the drop-down arrow that appears.
  6. Select one of the logical formatting options for the field from the list of available formats.
  7. When you are done, close the table and save your changes.

The Format Property for Yes/No Fields in Access: Video Lesson

            The following video lesson, titled “The Format Property for Logical Fields,” shows you how to set the Format property for Yes/No field in Access. This video lesson is from our complete Access training, titled “Mastering Access Made Easy v.2013-2007.”

TOP
Sale! $49 All-Access 0 Days 14 Hours 11 Minutes 16 Seconds      $199 $49 Entire Library!
See Deal