Hi,

I've a calculation field that creates a code from 5 other fields. What I want to do a build a check to ensure that I've all the parts to the code.

The code looks like this "H01-02-01-X ######"

H01 - Part 1

02 - Part 2

01 - Part 3

X - Part 4

###### - Serial No (length varies)

I thought that this would do it;

If(Identity Number Calculation ="h0#-##-##-@ *"; Graphic 2 ; Graphic 1 )

Do I need to get more complex and check each individual part that this code is created from?

Thanks in advance,

Skip

Case(

Identity Number Calculation = field1 & "-" & field2 & "-" & field3 & "-" & field4 & "-" & field5 ; Graphic 2 ;

Graphic 1

)

Thanks, I'll try it out.

Skip