If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Remove multiple rows of Null fields in a report
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? |
#2
|
|||
|
|||
Remove multiple rows of Null fields in a report
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] |
Thread Tools | |
Display Modes | |
|
|