How make Field_label shrinkable dependent on field value

  • Thread starter Thread starter rchristopher
  • Start date Start date
R

rchristopher

How code to make Field_label shrinkable dependent on field value in report?
Field value set to "can shrink" takes no vertical space in a report. How
code the Field_label to also take no space when the field value is null?
 
Right-click the label, and Change To | Text Box.
Set the Control Source of the new text box to an expression like this:
=IIf([City] Is Null, Null, "City:")
replacing City with the name of your field.

Set Can Shrink to Yes for this text box (substitutes for a label.)

Providing nothing else overlaps these controls vertically, they should
shrink.

Check that the (Detail?) section has its Can Shrink set to Yes as well.
 
Back
Top