Delete data from entire column 1

[Webkins]

I am using Access 2003. Besides dropping and adding the column, is there another way to delete the entire data contents of a single column using VBA ?

Thanks for the assistance.

 

[Remou]

You can use SQL in VBA.

strSQL="Update tblTable Set SomeColumn = Null"
CurrentDB.Execute strSQL, dbFailOnError

http://lessthandot.com