Invisible Text Boxes

[Brandon]

Hey everyone. I have a report that is linked to a table through a query.
What I was wondering is if it would be possible to hide text boxes that
contain certain values (like...nothing). What I have are three labels with
their respective table input values:

Intial Actions: Blah blah
Implementation: Blah Blah
Management Action: Blah Blah

Most of the time Implementation and Management action are emtpy, and thus
just put labels into my report with nothing to follow. This creates clutter
that I don't really want to show. So I'm wondering if you guys know how I
could hide the labels and their respective text boxes if their is nothing
there to show.

 

[Duane Hookom]

You can change the labels to text boxes and set their control sources to:
Control Source: ="Initial Actions: " + [InitActionField]
Can Shrink: Yes
Can Grow: No

If the field is Null, the "label" will disappear.

Duane Hookom
MS Access MVP