Supress label in report

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I would like to suppress the label for a field if no data
is present. For example if a field named cell phone does
not contain data I don't want the label "cell phone" to
appear in the report.
 
You can do this without code.

In report design view, right-click the label and Change To | Text box.

Set the Control Source of the text box to:
=IIf(IsNull([cell phone]), Null, "cell phone")
 
Mr. Browne suggestion is a better one (and one I intend to use). Thanks.

--
Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk


Allen Browne said:
You can do this without code.

In report design view, right-click the label and Change To | Text box.

Set the Control Source of the text box to:
=IIf(IsNull([cell phone]), Null, "cell phone")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Bob said:
I would like to suppress the label for a field if no data
is present. For example if a field named cell phone does
not contain data I don't want the label "cell phone" to
appear in the report.
Click to expand...
Click to expand...
 
Back
Top