Field Properties In Access (ENG)

Field Properties :

The nature of the field is another feature of the display tables ms access in 'Design View'. Its function is to

add characteristics to the table, to control the saiz of the field and to change the data type which is

Tex,Number,Currecy, Date/Time and many others.

Sifat Medan (field properties)	Keterangan
Format	Customize the way that the field appears by default when it is displayed or printed.
Caption	Set the text displayed by default in labels for forms, reports, and queries.
field size	Set the maximum size for data stored as a Text, Number, or AutoNumber data type.
Decimal places	Specify the number of decimal places to use when displaying numbers.
Input mask	Display editing characters to guide data entry.
Default value	Automatically assign the specified value to a field when a new record is added.
validation rule	Supply an expression that must be true to add or change the value in this field.
validation text	Enter text that appears when a value entered in this field violates the expression in the Validation Rule box.
text align	Specify the default alignment of text within a control.
smart tags	Attach a smart tag to the field.
Required	Require that this field must contain a value in every record.
Indexed	Speed up read access to data in this field by creating and using an index.  NOTE   The Memo and Hyperlink fields support indexes on only the first 255 characters of the field.  IMPORTANT   An index on a field causes append, delete, and update operations to take longer, because the index must be updated to reflect any changes.