Senarai field propetis(Sifat Medan)
|
Sifat Medan (field properties)
|
Keterangan
|
|
Format
|
Text : Customize the way that the field appears by
default when it is displayed or
Printed.
Memo
Number : More information about property settings
for these data types:
Show text.
Date/Time
Currency
: ShowNumber
AutoNumber
Yes/No : ShowDate/Time
Hyperlink : Yes/ No
|
|
Caption
|
|
|
field size
|
• Tex
Text
• Nu Number
• Au AutoNumber Set
the maximum size for data stored as a Text, Number, or AutoNumber data type.
More information about property settings for these
data types:
Text
Number
AutoNumber
TIP For best performance, always specify the
smallest sufficient Field Size.
|
|
Decimal places
|
Number
Currency
Specify the number of decimal places to use when displaying numbers.
|
|
Input mask
|
Text
Number
Date/Time
Currency
Display editing characters to guide data entry.
|
|
Default value
|
Text : Automatically assign the specifield values to a field when a
new record is added.
Memo
Number
Date/Time
Currency
Yes/No
Hyperlink
|
|
Memo
Number
Date/Time
Currency
Yes/No
Hyperlink
|
Text : Supply an expression that must be true to add
or change the value in this field.
Memo
Number
Date/Time
Currency
Yes/No
Hyperlink
|
|
validation text
|
Text : Enter text that appears when a value entered in this field
violates the expression in the Validation Rule
Box.
Memo
Number
Date/Time
Currency
Yes/No
Hyperlink.
|
|
text align
|
All data types :
Specify the default alignment of text within a control.
except
Attachment
|
|
smart tags
|
Text : Attach a smart tag to
the field.
Memo
Number
Date/Time
Currency
AutoNumber
Hyperlink
|
|
Required
|
All data types except : Require that this field must contain a
value in every record.
AutoNumber
|
|
Indexed
|
Text : Speed up read access to
data in this field by creating and using an index.
Memo : NOTE The Memo and Hyperlink fields support
indexes on only the first 255 characters of the field.
Number
Date/Time : 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.
Currency
AutoNumber : For more
information about indexes, refer to the See Also section.
Yes/No
Hyperlink
|
No comments:
Post a Comment