• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Working with Fields > Viewing Field Properties

Viewing Field Properties

Text Field Properties

FieldAction
Field SizeSpecify the maximum number of characters (up to 255) that can be entered in the field.
FormatSpecify how the data for the field will appear on the screen.
Input MaskSpecify a format or pattern in which data must be entered.
CaptionEnter 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 ValueSpecify a value that Access enters automatically.
Validation RuleEnter an expression that limits the values that can be entered in this field.
Validation TextEnter an error message that appears when a value prohibited by the validation rule is entered.
RequiredIndicate whether data entry is required.
Allow Zero LengthSpecify if field allows zero length text strings.
IndexedIndicate whether Access will keep an index of field values.
Unicode CompressionIndicate whether you want Access to save space if only plain text is entered.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint