Field within table

[crowegreg]

Using VBA, how do you delete a field within a table?

[June7]

Review http://www.w3schools.com/sql/sql_alter.asp

[MarcoRed]

So you meant that you're not gonna delete whole Record, Just one or two field(s)?
Let's try my solution! First you must create an "update" Button (using VBA work great). After you already created an "update" button, just take a look at any field you want to delete. Example: you want to delete a field "Name". First select that field and edit it (double-click on it to edit the field) and clear all the texts in that field and click on "Update" button (you just created). And every things are Done!
Enjoy! I prefer to use this method.

[crowegreg]

The ALTER TABLE is what I needed. Thanks!!