Hello all, Still trying to get a calculated field to work, and having no luck. Here's what I have: IF(CONTAINS("Ongoing",{project}.{name}),"KTLO-Ongoing",IF(ISBLANK({project}.{name}),"KTLO-General",IF(CONTAINS("Other",{project}.{name}),"Out of Office","Project"))) This expression works fine in a report, i.e. I can use valueexpression=IF(CONTAINS("Ongoing",{project}.{name}),"KTLO-Ongoing",IF(ISBLANK({project}.{name}),"KTLO-General",IF(CONTAINS("Other",{project}.{name}),"Out of Office","Project"))) This works perfectly. I now go to my custom form and enter the exact same formula, but tweaked for a calculated field
IF(CONTAINS('Ongoing',Name),'KTLO-Ongoing',IF(ISBLANK(Name),'KTLO-General',IF(CONTAINS('Other',Name),'Out of Office','Project'))) Now, here's where the problem lies, it evaluates the first statement correctly. It *does not* evaluate any other statement correctly, and falls through to the False statement at the end. Anyone have an explanation? P. Phillip Rinehart New York University