Change the field size for Text and Number fields

Change the field size for Text and Number fields

Use this procedure to control the maximum number of characters that can be entered into a Text field, or the range and kind of numeric values that can be entered into a Number field.

  1. In table Design view, in the upper portion of the window, click the field whose FieldSize property you want to set.

  2. In the lower portion of the window on the General tab, click the FieldSize property box.

  3. For a Text field, type the maximum number of characters to allow in the field (up to 255).

    For a Number field, click the arrow and select the desired field size. For more information on field sizes for Number fields, click .