In report design view, change the label into a text box and you can suppress
it.
Say the text box is named City, so the label reads "City:".
1. In report design view, right-click the label, and:
Change To | Text box.
2. Set the Control Source of the new text box to:
=IIf([City] Is Null, Null, "City:")
3. Set the Can Shrink property to Yes for both City and this new text box.
4. Make sure there is nothing else on the report that overlaps verticallly
with this these text boxes.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
Sue said:
I have a report in which a given field will have data only rarely. Can I
suppress display of the label & field for that data in the event the field
is
null, i.e. show the data only when there is data to show?
Appreciate your help.