Visible Statement on open

L

Linda Ribbach

I would like to make the text box not appear if there is no data in it and I want to have a border around the boxes that have data.

How can I program the report so that it only displays text boxes or borders when there is data in it?

Thanks Linda
 
M

Marshall Barton

Linda said:
I would like to make the text box not appear if there is no data in it and I want to have a border around the boxes that have data.

How can I program the report so that it only displays text boxes or borders when there is data in it?
Click to expand...


If CanShrink doesn't do it, you can use a little code in the
section's Format event:

Me.textbox.Visible = Not IsNull(Me.textbox)
 
Top