Conditional field display

  • Thread starter Thread starter Duane Hookom
  • Start date Start date
D

Duane Hookom

Use a text box with a control source of
=IIf(IsNull([YearCompleted],"", "Date completed: " &
Format([YearCompleted],"dd mmm yyyy"))
 
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?
 
Back
Top