Set field properties to customize how data is stored, handled, or displayed

The properties of a field allow you to customize how that field’s data is stored, handled or displayed.

What do you want to do?

Speed up searches on fields that are searched frequently, joined in queries, or sorted

Set the maximum size for a Text field, or the number size for a Number field

Set how many decimal places to display for a Number or Currency field

Define the display format for a field, such as a date's format

Define an input mask with literal characters and blanks to fill in for data such as phone numbers, postal codes, and dates

Define a label that is different from the field name for the field's column heading in Datasheet view, and for controls in forms and reports created by dragging the field from the field list

Define a value that is automatically entered when you add a new record

Limit data entered in a field to values that meet a certain requirement

Require that data be entered in a field

Allow zero-length strings to be stored in a Text, Memo, or Hyperlink field

Read about compressing the data in a Text, Memo, or Hyperlink field

Not sure which choice you want?