I get this problem with Yes/No (checkbox) fields in a left join query too. I fixed it by substituting the following expression for the [YesNoFieldName] itself: iif([YesNoFieldName],Yes,No)
This will return "No" (or an unchecked box) for a null value caused by the join query, but you can test...