Viewing Field Properties

Text Field Properties



Field Size

Specify the maximum number of characters (up to 255) that can be entered in the field.


Specify how the data for the field will appear on the screen.

Input Mask

Specify a format or pattern in which data must be entered.


Enter a label for the field when used on a form. If you don't enter a caption, Access uses the field name as the label.

Default Value

Specify a value that Access enters automatically.

Validation Rule

Enter an expression that limits the values that can be entered in this field.

Validation Text

Enter an error message that appears when a value prohibited by the validation rule is entered.


Indicate whether data entry is required.

Allow Zero Length

Specify if field allows zero length text strings.


Indicate whether Access will keep an index of field values.

Unicode Compression

Indicate whether you want Access to save space if only plain text is entered.


Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318 © 2008-2017.
If you may any questions please contact us: