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
- Select a table.
- Click Design.
- If the table is already open, click Design View.
- Click the name of the field that you want to format.
- Click the caption box.
- Enter the text for the label.
- Click Default Value.
- Enter the default value.
- Save changes.
Note: If you do not set a caption name then the field name is used as caption