• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Creating a Table > Entering a Caption and Default Value for a Field

Entering a Caption and Default Value for a Field

A caption appears at the top of a field in the table and next to the field on a form. For example, next to the field named “fname” in which you enter someone’s first name, you can create a caption that reads “First Name.” Entering a default entry allows you to set a value for a field that the user can still override. For example, you can set the default value for a Yes/No field to Yes.

To enter a caption and default value:

1.
On the Tables tab of the Database window, choose a table and click the Design button.

or

If the table is already open, click the Design View button.

2.
In the Table window, click the name of the field to format (Figure 31.27).

Figure 31.27. Add a caption and a default value for a field.


3.
Click the Caption box and enter the text that wil be used to label the field on the form.

4.
Click the Default Value box and then enter the default value.

5.
Save the changes to the table design.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint