Null memo field

[keo216]

is there any workaround for detecting if a memo field is null? I have a detail sub section that contains a 2000 character memo field. It is the only field in the section. If it's null I'd like the section to be suppressed but I don't know how to format the section to do that. My reason is that I can't see the memo field in the list of available format fields so can't use the memo field to control it.
Using V8.5
thanks
keo

kowen@rrwa.net

 

[vidru]

It won't show up in the Formula Editor, but you can type it in manually. I believe that this is the ONLY way Crystal will let you use a Memo field in a formula.
[tt]
IsNull({Table.MemoField})
[/tt]
-dave

 

[mrudolph]

This Link might give you some additional info or ideas for testing Memo fields for Null values and using that result for formatting or counting etc...

http://support.businessobjects.com/library/kbase/articles/c2007285.asp

 

[synapsevampire]

As Dave pointed out, Crystal will allow you to test for null on the memo field, and you can also create a SQL Expression and have the database return it which should prove faster. This is database/connectivity dependent, so post database info if you need assistance.

-k