Conditional field display

[Duane Hookom]

Use a text box with a control source of
=IIf(IsNull([YearCompleted],"", "Date completed: " &
Format([YearCompleted],"dd mmm yyyy"))

 

[David Frick]

I have a field called YearComplete that I want to display in a report.

The YearCompete field is displayed in a text box with special formatting and
is associated with a label.

If the YearComplete field is not null, then the report should look like
this:

Date completed: 21 Oct 1999

However, if YearComplete is null, then nothing should be displayed, neither
the field value nor the label "Date Completed"

Can anyone give me pointers on how to do this?