Labels not showing when no data is in record

[aackerman]

Hi,

I have created a report with subforms and I need the labels to show up when printing, even if there is no data to include on the report. These reports will be given to each employee and they will be updating their information, so it is vital that the headings show up so they know what information to give.

Thanks for your help!

aackerman

 

[trucktime]

Lables

Try this.
Put the following in the Control Source of the field in the report:

=IIf(IsNull([Employee]),"","Employee: " & [Employee])

If the Employee field is empty you will just get the Label 'Employee :'
else there will be the label and the field content.