Preventing Null Values from Displaying in a Report

[Guest]

I am trying to create a new Report and I have all the necessary labels and
information included, but I have some fields that are blank. I understand the
difference between a Null Value and a Zero Length String, but I'm confused on
how to prevent these from showing up on the report when it prints. I want to
set the fields so that if there is no information included, the label and the
blank field will not show. Is there anyway to do this?
--
Thank You,

Stephanie Rubino
Intern
Viatronix, Inc.

 

[Allen Browne]

You can set the Can Shrink property of a text box so that it shrinks to
zero-height in the report if it is null.

Labels cannot do that, but you can make it shrink like this:
1. In report design view, right-click the label and choose:
Change To | Text box.

2. Set the Control Source of this "label" to:
=([City] Is Null, Null, "City:")
where "City" represents the name of the text box this label is for.

3. Set the Can Shrink propery of this quazi-label (text box) as well.

In order to get the vertical space to actually shrink on the report, make
sure there is nothing else overlapping the control vertically (i.e.
partially beside it), and check that the Can Shrink property of the
(Detail?) Section is also set to Yes.