Page 249 - IT 402 v2.0 class 10
P. 249
Field Properties
he field properties control the behaviour of the field.
hey are related directly with the consistency in the data that is entered by the user. Following are the field
properties that are generally set for different fields in OpenO ce ase.
Entry Required: his property is applied if the field cannot be left blank i.e. it ensures that the user always
enters some data in the field.
Auto Value: It refers to the data or value that is automatically applied in the field. he user has to choose
es if this field should contain uto Increment values. One cannot enter any data in the fields of this type.
An intrinsic value is assigned to each new record automatically that is an increment of the value of the
previous record.
Length: his option specifies the length of the data that can be stored in a field.
For Numeric Fields: he default length of numeric data type in a field varies with respect to its type i.e.
Type of Number Max. Length (in character) of data
a Number N M I :
b Small Integer SM IN : 5
c Integer IN :
d Float F O : 5
e eal :
f ouble O :
For Text [Varchar] Fields: he default length of ext archar is fifty 5 characters.
For Yes/No [BOOLEAN] Fields: he default length of es No OO N is one character.
Default Value: his property is used to enter a default value a string in a field. hen the user enters the
data in the table the default value is used in each of the new records for the respective fields selected.
hen the user opens a table in datasheet view the value in the field is available in the cell.
Format: This property is used to determine the format of the output of the data. One can set the format
by clicking on the ... button that lies beside the Format example text box in the Field roperties window.
ext alignment can also be defined in the lignment tab of Field Format window.
Database Management 247

