IsNull code not working in report

[jerry001 via AccessMonster.com]

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!

 

[John Spencer]

It is possible that the field is not null but contains a zero-length string.

Try changing the test to

IF Len(Me.Field1 & vbnullstring) = 0 Then
Me.Field1.Visible = False
Me.label1.Visible = False
Else
Me.Field1.Visible = True
Me.label1.Visible = True
End If


If that does not work for you perhaps you can expand a bit on what "It does
not work." means. Does the label remain visible when you want it hidden? Or
does the space not shrink?

Also, it might help if you tell use WHERE (which event you are using)

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[jerry001 via AccessMonster.com]

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!

 

[Steve]

Where do you have this code?

Steve
(e-mail address removed)

 

[Gina Whipp]

Jerry001,

Try...

If Me.Field1 = "" Then
Me.Field1.Visible = False
Me.label1.Visible = False
Else
Me.Field1.Visible = True
Me.label1.Visible = True
End If


--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

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!