How do I Eliminate Blank Fields in a Report?

[Guest]

in an access report, when a field has no data in it, how do you "slide the
fields up"? For instance, if an address has the company, name, address,
city, state, zip for fields, and the contact has no "company", how do you
keep the printout from looking like this:

John Doe

1220 Lone Lane
Ft. Wayne, IN 46835

 

[Rick B]

You can make each control zero-height. In other words, squeeze them
vertically so they turn from a box to a line. eliminate all the space
between them (squeeze them together).

Now set each of them to "can grow = true" in their properties.

You can do the opposite and leave them like they are, then set the "can
shrink" to true. Make sure to set your detail section to "can shrink" as
well.

Rick B