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.

Notes

• If other database objects contain references to a deleted field, you need to delete those references as well. For example, if a report includes a control bound to a 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.