Supress field and label if blank

[statsman]

I have read some threads in the search mode on this but I haven't found what I'm looking for.

I have seven fields in the "Report Header" section (I am using the detail section for another function which prints on a separate page). If the field is blank, how do I supress the field and the field label from the report?

Medium VBA skills.

Many thanks

 

[pbaldy]

Empty fields often indicate a normalization problem, but you should be able to test the value of the field in the format event of the section and set the visibility of those controls as appropriate.

 

[statsman]

My fault for being unclear.

The report deals with complaints made to the client. There are up to seven areas the complaint investigator may have to check. However, not all areas have to be checked for each complaint. As a result, not all of the fields have to have data entered into them.
I wish to supress those fields where no data was entered because this area didn't need to be checked.

 

[pbaldy]

I would say that is a normalization problem (repeating fields). They should probably be records in another table, so that only the items that are filled out become records. In any case, the method I described should work to suppress the unused fields.