After further playing around with the triple state of my checkbox is that at least in Access 2010 you cannot put anything in the default value for the checkbox.  The video says to set that to False but maybe that worked in 2007, in 2010 at least it makes the checkbox act like its locked and so it won't change state.

---

Reply from Richard Rost:

I'm not sure what you mean. You can set the default value of a check box to YES, NO, or (in the case of a tri-state) NULL. I know for a fact that this works in Access 2007 and 2013. I don't see why it wouldn't work in 2010.