Supress label in report

[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.

 

[Jesse Avilés]

If IsNull textboxName then
textboxNameLabelName.visible = false
End if

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

 

[Allen Browne]

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")

 

[Jesse Aviles]

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

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.

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.