Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

Property type

Description

Validation Text

Creates an error message to appear when the data entered violates a validation rule

Required

Specifies that the field cannot be left empty

Allow Zero Length

Determines whether or not you can enter quotation marks (“ ”) in a Text , Memo or Hyperlink field to indicate that there is no data for that field Speeds up retrieval of data in a field; all primary key fields are automatically indexed

Indexed

NOTE If a table has reports or forms associated with it, you may want to apply changes you make to field property settings in a particular table to the corresponding property settings, or bound controls, in the joined forms or reports. You can do this by selecting the Property Update Options button that appears next to the field when the property is changed. You can then select the Update Format everywhere < field name > is used command and then select Yes in the Update Properties dialog box to apply the settings to the bound controls.

L IMITING F IELD S IZE



Discussion

Setting a field size limits the number of characters or the type of characters you can enter into a field. After typing the maximum number of characters allowed, further keystrokes are not permitted. The Field Size property is available only for Text , Number , and AutoNumber data types; all other data types have default sizes that are set automatically.

OFFICEPRO, Inc.

Page 3