We have a report where the design is as follows:
The IdInfo control is based upon an IIf statement to combine four fields of the table. Summary is a Total Access Memo ActiveX add-in to allow for formatting of the text in the memo field. In certain instances, IdInfo will contain no data and, therefore, leaves a blank space in the report. What can we do to get rid of that blank space when there is no data to fill the IdInfo control?
see this link
How to eliminate white space in reports with CanShrink and code in Access