If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
IsNull code not working in report
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 wrote: 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! |
#3
|
|||
|
|||
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 |
#5
|
|||
|
|||
IsNull code not working in report
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 "jerry001 via AccessMonster.com" u48786@uwe wrote in message news:a6ee5ee0a50ec@uwe... 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 |
Thread Tools | |
Display Modes | |
|
|