hiding text and boxes in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to only show text boxes in a report only when there is related data and on other lines of the report hide it when there isn't any data?
 
There are a couple of ways.

1) Set the Can Shrink property of the textbox to Yes. This will allow it to
shrink to zero height if its value is Null. This will also allow objects
below it to move up. This will only work if there is nothing else in line
horizontally with the textbox that would still need to space.

2) In the Format event of the section the control is in you can use VBA to
determine under what conditions you want the control hidden and set its
visible property to True or False.

--
Wayne Morgan
MS Access MVP


ClaimsDatabase said:
Is there a way to only show text boxes in a report only when there is
Click to expand...
related data and on other lines of the report hide it when there isn't any
data?
 
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

Access Textbox - Hide Cursor 0
Invisible Text Boxes 1
hide a text box that has calculation in it.. 2
Text box names appear in report exported to Word 1
Access Access Report Works on One Machine but not Another 3
Report Text box dilemma 4
Programatically hide one menu 2
Unbinding all a Reports ControlSources 3

Back
Top