How to Understand Field Types and Properties in Access
Because there are so many different types of data, Access offers several different types of fields. A field’s data type restricts what type of information can be stored in a field. For example, you cannot enter text into a number field.
You can also change a field's properties. A property is an attribute that defines an object’s appearance, behavior, or characteristics. For example, a car’s properties would include its color, make and model, and shape. A property for a numeric field might be the number of decimal places displayed or the maximum number of characters a field can hold.
To view and modify the Field Properties for a table, open the table in Design View.
In Design View, click the field that you want to change the properties of.
Click the property box you want to change and enter or select the new settings.
The table at the end of this lesson describes many important field properties. Don’t worry if some of them seem confusing—you’ll get plenty of practice adjusting them in other lessons.
It’s important to note that certain types of fields have their own sets of properties, so the properties may be different depending on the field.
Important Short Text Field Properties
Field Size
Text fields: The maximum number of characters (up to 255) that can be entered in the field. The default setting is 50.
Number / Currency fields: Stores the number as a Byte, Integer, Long Integer, Single, Double, or Replication ID, or Decimal. The default setting is Long Integer.
Format
How the data in the field will be displayed on the screen.
Input Mask
Creates a format or pattern in which data must be entered.
Decimal Places
The number of decimal places in Number and Currency fields.
Caption
A label for the field that will appear on forms. If you don’t enter a caption, Access will use the field name as the caption.
Default Rule
A value that Access enters automatically in the field for new records.
Validation Rule
An expression that limits the values that can be entered in the field.
Validation Text
The error message that appears when an incorrect or restricted value is entered in a field with a validation rule.
Required
Specify if a value must be entered in the field. The default is No.
Indexed
Index the field to speed up searches and sorts performed on the field. The default is No.