Aug 9, 2004 #1 BreffniK Technical User Apr 27, 2004 24 US Thanks for taking the time to read my question. What is the correct syntax to conditionally suppress a section of the report depending on whether or not a field is null? Any advice would be greatly appreciated! Thanks!
Thanks for taking the time to read my question. What is the correct syntax to conditionally suppress a section of the report depending on whether or not a field is null? Any advice would be greatly appreciated! Thanks!
Aug 9, 2004 #2 Turkbear Technical User Mar 22, 2002 8,631 US Hi, Try: Code: IsNull({table.field}) or {table.field}="" Tests for NULL and Blank.. Upvote 0 Downvote
Aug 9, 2004 #3 Kevinski Technical User Jan 4, 2001 95 NZ or even isnull({table.field}) or {table.field} = '' or {table.field} = ' ' Upvote 0 Downvote
Aug 10, 2004 #4 kskid Technical User Mar 21, 2003 1,767 US Just to make sure it's not filled with blanks, isnull({table.field}) or trim({table.field}) = Upvote 0 Downvote