Change the field size for text and number fields

See Also

1. Open the table in Design View

2. Select the Field.gif Fields tab

3. Select the row of the field you want to change

4. In the property box of the field, enter the new Length of the field

5. Select Save.gif Save… or SaveAs.gif Save As… from the File menu when you are ready to save the table

Note: Be careful when shortening the length of a field because it may result in loss of data for that field if there are records in the table whose values are longer than the new length.