I want users to enter an explanation of cost variances if they exist in a
Note box. Currently I force this by checking the length of text input into
this box (say B10) if the cost variance (say in A1) exceeds a certain
amount. But is it possible to disallow from input if the text is a
continuous string of the same character eg xxxxxx or AAAAAA. Some employees
have worked it out that the Text box only requires a minimum of 10
characters in length so they just enter xxxxx (10 times) etc

Thanks