How do I edit a column value to be Null

Question

I'm trying to set referential integrity in my back-end relationships but it wont let me. I ran a join between the tables and it found one mismatched row which has blanks in the join column. How do I set this column to null via datasheet editing? I tried hitting delete and that did not work, I guess it left an empty string in there.

Answer 1

Why not use an Update query to correct it?

UPDATE MyTable
SET MyField = Null
WHERE MyField = ""

---

Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)

Answer 2

Backup your database then use an update query.

Answer 3

I used your solution but it would be really nice if there was a way to do it via datasheet editing.

Answer 4

I used your solution but it would be really nice if there was a way to do it via datasheet editing.

Since an empty string is not physically displayable there is nothing to highlight. Hence Delete won't work.

---

Bill Mosca
http://www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals