Defaults and Required Values
Now we will show you how to setup default values and specify whether or not values can be left blank.
Default Value
It is used to specify a value that is automatically entered in a field when a new record is created. For example in the employee table you can set the default value of the field ‘state’ to ‘Washington’.
Note: When you add a record you can either accept this value or enter the name of a different city. The default value applies to all table fields except those fields with the data type of Auto number or OLE object. The maximum length for default value settings can be 255 characters.
Allow Zero Length
A Zero length string can be entered in a field. If Zero lengths are not allowed then the field must either contain a value or a null. It applies only to text, memo and hyperlink table fields.
Required Values
This specifies whether or not a value is required in a field. This property is set to No by default. By selecting Yes, you can enter a value in the field or in any control bound to the field. Thisdoes not apply to AutoNumber fields, which can be used toensure that a particular field or control bound to a field always has a value (never Null).
