Conditional label format

[Marion Zapolin]

Is there a way to format a label so that it will not show
on a report if a corresponding field is blank or has a
value of zero? Also, if the label and field value (set to
can shrink) do not show on the report, can I delete the
entire blank line?

 

[Duane Hookom]

The trick I have used is to change the label to a text box. Set the control
source to an expression that includes the field name. For instance if the
field name is [SpouseName], you could set the control source of the "label"
text box to:
="Spouse Name: " + [SpouseName]
Set the text box width to display only "Spouse Name:". If the field is null,
then the entire contents of the text box become null also. Setting the
control's Can Shrink property to Yes will remove the text box.