Hide Null Fields (Stacked)

[ehaze]

In my report footer, I need to hide fields that are null but keep the remaining fields together. Each fields control source is a formula / expression builder output.

Report Footer:
Field1
Field2
Field3
Field4

Desired output
Field1
Field4

In this example, Field2 and Field3 are the only null fields.

I've tried setting the field height to 0, stack all of the controls on each other, then set Can Grow to yes. The fields displayed over each other.

http://www.sharepointed.com/

 

[dhookom]

What are the expressions in the control sources?
Make sure there is no overlapping of the text boxes.
Make sure there are no labels or other controls to the left or right of the text boxes.

Duane
Hook'D on Access
MS Access MVP

 

[ehaze]

Duane,
Thanks for the reply.
Ended up doing an expression that contained all the needed fields / sources.
Fixed the issue.

http://www.sharepointed.com/

 

[SkipVought]

Please post your solution for the benefit of other members.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]