IsNull on Memo Field 1

[woolade]

I have recently upgraded to CR 10 from CR 8.5. The following formula suppressed records if the field {CL_CALL_LOGGING.PROBLEM_DESC} was blank in 8.5 but doesn't suppress them in CR 10;

IsNull({CL_CALL_LOGGING.PROBLEM_DESC})

The field is a memo field. Is anyone aware as to why this doesn't work in version 10?

Thanks

Adrian Woolman

 

[synapsevampire]

Could be the convert null values to defualt is on.

Anyway, try:

(
isnull({CL_CALL_LOGGING.PROBLEM_DESC})
or
{CL_CALL_LOGGING.PROBLEM_DESC} = ""
)

-k

 

[woolade]

Thankyou synapsevampire, that worked.

AW