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

Ok I have a dbase with 5 tables
I need to print reports for each table but since there are many null values I
need to hide them (and their Labels as well).

I used the following code

If IsNull(Me.Field1) Then
Me.Field1.Visible = False
Me.label1.Visible = False
Else
Me.Field1.Visible = True
Me.label1.Visible = True
End If

It does not work.

Most of the fields are text fields.
The Canshrink/Cangrow var is True
The following code works for the forms.. but not the reports...


I read rellevant threads but still no luck!

Any help will be greatly appreciated!

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