Doesn't do it for me?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)
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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.