Remove multiple rows of Null fields in a report
in [Reports]
|
From: Brad on 7 May 2010 13:49 I have created a report with multiple lines of data that could be null. I set the fields to "can shrink." It does shrink the line and move it up a field but if I have multiple fields in a row it does not bring the field all the way to the top. Any ideas?
From: Marshall Barton on 7 May 2010 17:35 Brad wrote: >I have created a report with multiple lines of data that could be null. I set >the fields to "can shrink." It does shrink the line and move it up a field >but if I have multiple fields in a row it does not bring the field all the >way to the top. A CanShrink text box will shrink, but the section containing it can only reclain the otherwise **empty** horizontal bands that were occupied by the text box (and/or other shrinking text boxes). Depending on all the other stuff in the section, you might get closer to what you want if you can make the all the text boxes shorter and set them to CanGrow. Regardless of what you do, no text box below the CanGrow/CanShring text boxes can end up with its Top above the bottom of the bottom of any control above it. Also, any control with its Top above the bottom of a CanGrow/CanShrink text box will neither move up or down. -- Marsh MVP [MS Access]
|
Pages: 1 Prev: How to Imporve Report Perfomance Next: Report showing #Error on a valid SQL View |