Delete a field from a table

When you delete a field, remember that if other database objects contain references to the deleted field, you need to delete those references as well. For example, if a report includes a control bound to the deleted field, Microsoft Access won't be able to find the data from the field and will generate a message.

You can't delete a field that's part of a relationship—-you must delete the relationship first.

Delete a field from a table in Design view

  1. Open the table in Design view.
  2. Select the field or fields you want to delete.

    To select one field, click that field's row selector.

    To select a group of fields, drag through the row selectors of those fields.

    1  Row selectors

  3. Click Delete Row on the toolbar.

Delete a field from a table in Datasheet view

  1. Open the table in Datasheet view.
  2. Click the field selector of the column you want to delete.

  3. On the Edit menu, click Delete Column.