Hide row when field is blank/null/empty

[kbear]

I have been trying to hide a row in RS when one field is blank. I cannot find the syntax for this after two hours of searching. Can someone tell me if I want to use IsNothing, Is null, ="", or what? Cannot figure out how to test for null in RS which seems to use different sytax than any other program I've ever used. Thank you.

 

[SgtJarrow]

Putting the following in the Hidden property for the row has always worked for me:

=IsNothing(Fields!PaymentTermsID.Value)

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[kbear]

This doesn't work. I finally used this formula
=iif(Fields!MEMO.Value="",true, false)

which I couldn't get to work yesterday. Maybe my true's and false's were backwards.

Thank you.

 

[dhulbert]

Hi Guys.
Sorry to hijack you but How about the same thing but reversed so hide Columns when there is no data in any row in theat column?

Cheers.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[xlbo]

You can use exactly the same logic as for the rows but applied to the column
However, I don't know about 2005 but in RS 2000, the columns are hidden but the following columns do not shift over to fit - you just get a blank space where the column would be....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question