hide label if no data

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

Guest

I have a report with a field [SeparationDate]. This field is labeled
"Separation Date:" The report has only one record per page. Can hide the
label if the field itsself is null? (Conversely, have the label appear when
the record is given a SpearationDate?) Thanx! Dave
 
Right-click the label, and choose Change To | Text box.

Set the ContolSource of the text box to:
=IIf([SeparationDate] Is Null, Null, "Separation Date:")
 
1. You can link the label to the text box, that way when the value wil be
null the Lable wont show up
Select the lable, cut , select the text box and paste

2. On the On Print event of the section where the text box is in, you can
write the code

Me.LableName.Visible = Not isNull(me.TaxtBoxName)
 
One other method. Change the label to a text box and set the control source
to:
="Separation Date " + [SeparationDate]
Make sure the box can't grow and is only wide enough to display "Separation
Date".
 
Back
Top