empty field

[cc]

If a field is empty, how can I have the space it would have taken up in the
report not show. In other words, when a field on a line is empty, have the
next line of the report move up so that it follows the last field that had
information.

 

[Allen Browne]

In report design view, right-click the text box and choose Properties.
Set the Can Shrink property to Yes.

Provided there is nothing else alongside it at all, it will then shrink
vertically, i.e. things below it will move up to take its place.

If the text box has an attached label and you want to suppress that too,
right-click the label and Change To | Text Box. Then set the Control Source
of the new text box (the quazi-label) to an expression that makes it null
when the text box is null. For example, if the text box is named City, use:
=IIf([City] Is Null, Null, "City:")

 

[Jeff Boyce]

Open the report in design view.

Highlight the control that displays that field.

Open the Properties window.

Find Can Grow and Can Shrink properties -- set them both to "Yes".

Save and close.

Try it now.

Regards

Jeff Boyce
Microsoft Office/Access MVP