Conditional label format

  • Thread starter Thread starter Marion Zapolin
  • Start date Start date
M

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?
 
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.
 
Back
Top