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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Borders? 3
Can Grow property 5
Report Text Box visible or not 2
Excel Move or Copy Stopped Working? 0
Displaying controls as separated values in boxes on a report 4
Detail Border 3
Variable Row Heights in reports? 2
Strange border when printing a form 3

Back
Top