Set text field to null?

[gorilla1]

I have searched around, but I cannot find this: how do I set a text field in the (access) database that already has text in it to null?

[miranda]

use the update command

UPDATE myTable SET myField = 'Null' WHERE myUniqueIdentifier = " & uniqueIdentifier

or

UPDATE myTable SET myField = '' WHERE myUniqueIdentifier = " & uniqueIdentifier