Probably a simple one

[life036]

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

[QuinTech]

Length ( fieldName ) = 15 or IsEmpty ( fieldName )

Is that simple enough?

HTH,

Jerry

[life036]

Gotcha. I was running into trouble because it was a number field and I was inputting periods. Thanks!