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?
 
Back
Top