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