Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hide Null Fields (Stacked)

Status
Not open for further replies.

ehaze

Technical User
Oct 16, 2009
254
US
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.

 
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
 
Please post your solution for the benefit of other members.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top