Nevermind. I guess it would help for me to activate my conditions. I had the answer all this time and forgot to put a checkmark next to my condition to activate it.
This validation will return an error for any entry that contains more or less digits than 9, including extra space.
I realize that you have already solved your problem, but I did want to point out that I usually approach this type of problem from a different angle. What I would normally do is to go into "Manage Database", and modify the field's definition so that it will have an auto-enter calculation. Its definition could be Trim(SELF) You will also need to make sure that the calculation will overwrite existing values. This should stop this problem instead of just visually identifying it.
That won't work for my immediate purposes, but that is a great tip for cleaning that up in a dedicated Filemaker Database. I'm just identifying the errors in the data, so I can create a report for the users to cleanup. I've got probably close to 100 users that enter data. If everyone of them makes 1 mistake then I need to clean 100 mistakes. I want to turn that back to them so that each of them is able to clean their own work, which leaves me open to work on the stuff I'm supposed to be working on.
I didn't know about the Trim Command. That will come in handy.