Trying to hide Label on a Report

[TJBernard]

This shouldnt' be as tough as I am making it out to be for myself, so I decided to come here to ask. I have a simple report, based off of a table, and I have the Text Boxes Can Shrink and Can Grow Properties = Yes. I want to hide the Labels of all the Text Boxes where the Can Shrink property kicks in because the Text Box contains a Null Value.

I have tried the LenB function on the Text Box through code, and I have tried the IsNull function through code, neither have worked.

If anyone has tried this before, or has any ideas, I would greatly appreciate it.

Thank you for your time,

T.J.

 

[Rich]

Me.MyLabel.Visible=Not IsNull(Me.MyField)
in the on format event

 

[TJBernard]

Thank you very much, worked perfectly.