[RESOLVED] delete a field contents

[Muddy]

Why does this delete the contents of all the fields in myTable instead of just the field myField???? How can I delete the contents of a single field using adodb.command??

Dim cmd As New ADODB.Command
cmd.CommandText = "DELETE myField FROM myTable"
cmd.Execute

Thanks for any help!!!