Unanswered: removing white empty space on an access report when no data is present.
Hi everybody! Please bare with me if this has already been asked but my searches came up empty. So I thought it would be safe to ask this question. I am constructing a database from scratch that manages enrollment at a school. It is a directory of students, parents, birth days, etc etc. I have a total of 23 controls in the detail section of my report. I say 23 because I am counting each object as a control so each text box label and the associating text box (representing the field of the query) I count as two. One label by itself I am counting as one. What I have done is create a series of macros that checks whether the text box contains data. If it is null, then the field turns invisible. If the next record has data in that field, the field on the report becomes visible again. However, when the report runs it prints empty spaces where the data would be if it was in the record. Is there a way to collapse the white space so that the report only prints/displays data.
I wanted to also point out that my research does reveal a can shrink solution but I am not versed on how to do that. I have read that people can get the data boxes to shrink but their corresponding labels dont shrink too. I also have read something about a createreportcontrol method. I do not understand how to implement. I have used the TRIM statement when working with labels but this is not for labels. It is for a brocheur or directory. All suggestions are most appreciated. Thank you.
dim ctl as control
for each ctl in me.controls
if typeof ctl is textbox or typeof ctl is combobox then
if typeof ctl is checkbox then