nmoudgil
10-29-2009, 10:16 AM
I have a report that has ONE QUERY attached to it. In the screenshot (Attached) It displays 1st line from a record then the second line is displayed from the same record but has different values which are blank or null. I want to be able to remove all these BLANK spaces between the records how do I go about doing that? Of course sometimes the second line DOES have values which gets displayed but I don't want the BLANK spaces to appear between records at all even if the values are blank or null.
boblarson
10-29-2009, 10:24 AM
Set the detail section's CAN SHRINK property to YES and also each control's CAN SHRINK property to YES.
nmoudgil
10-29-2009, 10:31 AM
Set the detail section's CAN SHRINK property to YES and also each control's CAN SHRINK property to YES.
Wow I feel pretty dumb right now. You are right! Man wat a simple fix. Thanks a lot!
boblarson
10-29-2009, 10:37 AM
Wow I feel pretty dumb right now.
Don't sweat it. If you don't know how to do something, it isn't necessarily easy because you don't know where to look, or what to look for. So no worries. :)