Access Report Question

[jasonpence]

I have a problem with a report I have created in access. I have many
fileds whioch contain no data and I would like to hide the labels for
those empty fields in the report. Does anyone have any idea how to do
this?

 

[Duane Hookom]

Sounds like an un-normalized table structure but I could be wrong. If you
want to hide the label for a field named "MyField" when all of the records
contain a Null value for either a group or the report, change your label to
a text box with a control source like:
=IIf(Count([MyField])>0,"My Field Label",Null)

I have a feeling you might have additional requirements.