I'm sorry, I should have read the entire thread, I'd have seen that. Well in any case, that method still addresses point B of the original question, in that it highlights questions for the end user without requiring the addition of notes fields.
It might be possible to have a single notes field validate the character counts on multiple other questions using a series of coalesce statements, but this is likely to be more complicated that just using constraints.
What's the use case here where a related table is being edited and possibly exceeding the original word count, instead of simply adding new entries?
- Josh Carlson
Kendall County GIS