Hiding report field

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

I have a report where all the output data is displayed in nice looking
boxes.

Problem is that sometimes there is no data in some of those fields. In that
case I wish to completely hide that field and it's label.
I can't seem to find how to do this.

Any ideas?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Right-click the label, and choose Change To | Text Box.
Now enter a control source that yields nothing when the other text box is
blank.

For example, to show the word "City" only when the City text box has a value
in it, you would set the Control Source of its "quazi-label" text box to:
=IIf([City] Is Null, Null, "City")

If these two boxes are perfectly aligned vertically and do not overlap other
controls, you may be able to set their CanShrink property to Yes if you wish
to remove the space they occupied.
 
Back
Top