hide label if no data

[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

 

[Allen Browne]

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:")

 

[Guest]

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)

 

[Duane Hookom]

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".