I'm using 2003, but I assume the same applies in 2007.

- Create a new macro.
- From the Action dropdown, select RunSQL.
- In the SQL Statement box enter:

UPDATE [TableName] SET [FieldName]=NULL;

- Save the macro.

Run the macro to delete the data from FieldName in TableName.