|
Answer» Field Properties After you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality. Some important properties of field are as follows: | Field Property | Description | Supported by | | Field size | It limits the number of characters that can be typed into a field. | AutoNumber, Text, Number. | | Format | It customises the way that text or numbers are displayed and printed. | Text, Memo, Number,DateTime, Currency, Auto Number, Yes/No, Hyperlink. | | Input Mask | It sets up the field to receive data in a particular format. | Text, Number, DateTime,Currency. | | Caption | It adds a label to the field to assist the user. | All data type. | | Default Value | Sets a value to appear in the field before you enter any data. It is used to avoid the type | Text, Memo, Number,Date/Time, Currency, Yes/No, Hyperlink. | | Validation Rule | A condition that must be meet before the data is accepted into the database | Text, Memo, Number,DateTime, Currency, Yes/No, Hyperlink. | | Validation Text | This appears if a validation rule is not satisfied. | Same as a validation. | | Required | Makes data entry compulsory, so that field can not be left blank. | Text, Memo, Number,Date/Time, Currency, OLE Object, Hyperlink, Attachment. | | Indexed | To speed up queries, sorting and grouping operations or to prevent users from entering duplicate values. | Text, Memo, Numbers, Date/Time, Currency, AutoNumber, Yes/No, Hyperlink | | Smart Tags | Attaches smart tag to the field. | Text, Memo, Number,Date/Time, Currency,AutoNumber, Hyperlink. | | Text Align | Specifies the alignment (i.e.general, left, center etc.) of text within a control. | Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLE Object, Hyperlink. |
|
