Question -
Answer -
It refers to the maximum number of characters that a field can contain. Each character requires one byte for its storage.
Field length is of two types which are as follows:
1. Fixed length field It is a type of field length in which the number of characters you enter in a field is fixed. These are present in Format option in Data Type Formatting group (in Datasheet tab) such as Currency, Euro, Percent etc.
2. Variable length field In this type of field length, the number of characters is not fixed. Actually, the number of characters of the data entered in the field decide the field length.
The field length or field size of each data type are as follows: