What's with the type mismatch?

[Welshgasman]

Both post #9 and Conditional Formatting solved the OP. The only downside the is with CF'g is that, in design mode, the TB's show the back color shading of those fields that are subject to special processing. I.e., in need of shading when null. (I realize I can add some additional CF'g when Not IsNull)

Doesn't do it for me?

[pbaldy]

Me either, unless I'm misunderstanding what you're saying. Textboxes don't look any different in design view whether they have CF applied or not.