Skipping Blank Fields

[Guest]

I am trying to produce a report where I skip fields that are blank. I
changed the property for each field to Can Shrink. However, the report still
produces blank lines for null fields.

Afer that didn't work, I tried creating a query that would only accept Is
Not Null fields. I set that criteria for every field where data may or may
not exist for a given record. However, it took that as "all or none" and
only produced records where each and every such field is populated. I want a
query that produces a result for every record that has at least one populated
field (each record does).

Any help would be much appreciated!

 

[Al Camp]

Ken,
Use the Can Shrink/CanGrow, but make the field heigth 0...
If there's data it will Grow, if not it will be 0" high.

 

[Guest]

It may be that there are non-shrinking controls alongside the ones you want
to shrink. These could be labels or graphical elements such as lines. If
this is the case then the bound controls won't shrink if Null. Also make
sure that the controls are vertically contiguous with no 'white space'
between them as only the space occupied by the control itself shrinks.

Ken Sheridan
Stafford, England