Write about field properties?

Field Properties

Answer: Each field has several properties. Field properties are displayed depending on the data type. Properties determine the shape of the field, how the data will be displayed and controlled.

Some of the properties are discussed below:

1. Field Size: How many characters the field size will be can be determined here.

2. Format: How and in what format the text information will be displayed can be determined from here.

3. Input Mask: There is input mask property for data like Text, Number, Date Time and Currency. How data is inputted in all these fields can be controlled by input mask.

4. Caption: If you want to display the heading for a field in Datasheet view, you have to set this property. Heading can be up to 255 characters.

5. Default Value: Default value can be set for all fields except Auto number and OLE object. If there is any common data for a field, it can be mentioned as Default value, so that when inputting the record, the Default value will be automatically input in that field.

6. Validation rule and validation text: Each field has its own Validation rule and Validation text properties. Validation rule confirms the data while inputting any data in the field. Validation rule If no data is confirmed, the information Validation rule is displayed.

7. Required: This property determines whether data input in a field is required or not. While inputting data, this data cannot be left blank and moved to another field.

8. Allow zero length: Zero length string can be input. Zero length string data is enclosed by input (double quotations).

9. Index: This property is used for indexing.