April 5, 200520 yr I'm trying to enforce validation on my number field by using a calculation - the number field has to be 15 characters long, no more and no less. The only exception is if no data is entered at all, or zero characters. I can't seem to build a calculation that makes this work. You fellas have any ideas? Thanks Chris
April 5, 200520 yr Length ( fieldName ) = 15 or IsEmpty ( fieldName ) Is that simple enough? HTH, Jerry
April 5, 200520 yr Author Gotcha. I was running into trouble because it was a number field and I was inputting periods. Thanks!
Create an account or sign in to comment