How does a user insert a null in MS Access?

Question

MS Access appears to support nulls in code, but I can't for the life of me figure out how to enter a null directly in a table. This is maddening because once a field has had a figure entered in it, it can never be deleted/set to null. Normally, allowing zero length strings would take care of this, but Access treats the XML export of a null and a zero length string differently. A null eliminates the associated XML tag and a zero length string sends an empty tag.

Answer 1

Does setting the "Allow zero length string" option in the table definition help? It may force an empty string to be interpreted as NULL.

Answer 2

Are you talking about needing to do it in Datasheet view? If you needed to do it in an update query, you can do it like this:

UPDATE test SET test.test = Null;