Thread
:
IsNull code not working in report
View Single Post
#
4
April 22nd, 2010, 11:38 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
Posts: 1,017
IsNull code not working in report
Where do you have this code?
Steve
"jerry001 via AccessMonster.com" u48786@uwe wrote in message
news:a6ed2a10e9c21@uwe...
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
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]