View Single Post
  #3  
Old April 22nd, 2010, 11:32 PM posted to microsoft.public.access.reports
jerry001 via AccessMonster.com
external usenet poster
 
Posts: 7
Default IsNull code not working in report

Thank you for the quick response but that won't work.
I get the "entered an expression that has no value" error.

As you guessed the problem is that the field and the label remain visible.
When I enter the code without the "If" statements it all works fine and hides
the Label and Field.
(Just the "Me.Field.Visible= False" line..)
So I suppose that there is something that's blocking access from recognizing
the value of this field as Null. It's a mystery to me because I am using the
same code in a form and it works just fine!


Any other suggestions?

thanx!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1