Home » Microsoft Access » 06 - Fields
6

Entering a caption and default value

Michael decides to enter captions and default values in the fields to make the database user-friendly and easy to operate.

What is a caption and default value?

A caption appears at the top of a field in the table and next to the field on a form. For example you can create a caption that reads “Last name “next to the field “lname”. You can enter a default value for a yes / no field to Yes. You can override this value anytime.

Entering a caption and default value

  1. Select a table.
  2. Click Design.
  3. If the table is already open, click Design View.

  1. Click the name of the field that you want to format.
  2. Click the caption box.
  3. Enter the text for the label.

  1. Click Default Value.
  2. Enter the default value.
  3. Save changes.

Note: If you do not set a caption name then the field name is used as caption