Visible Statement on open

  • Thread starter Thread starter Linda Ribbach
  • Start date Start date
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
 
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)
 
Back
Top