Dave,
Your example is correct. And, yes, the account numbers vary in length of characters and by format.
The account number field reflects an account number associated with any utility purchase with any supplier primarily in the states of PA, DE and NJ whether it be electric, gas, water...
I'm sorry if I were misleading. I don't want to eliminate the spaces from a string. I want to disallow the entry of a space in the account number field. That's why I thought that a validation rule of some sort would work.
I thought of the imput mask suggestion, however, there's just too...
There's probably a simple solution to this question.
I have a field in my database for account numbers. And since the format of these account numbers vary significantly, I was wondering if there's a way, perhaps, via a validation rule, to eliminate spaces and I'm really not sure how to do it...
Thank you for responding Durkin. I've been out for a couple of days but I'm sure the databases are still crashing. The message says something like "not a database" and asks if we want to rebuild. This crash is happening with any one of five to eight user's machines. I read another...
Two of my companies databases have consistently crashed over the last couple of weeks. I'm at my wits end. I've done everything I can possibly think of...compact and repair, called Microsoft (they were no help), reformatted some forms that possibly could have been corrupt, created a new...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.