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?