No record returned displays unwanted gap

  • Thread starter Thread starter kk
  • Start date Start date
K

kk

I have a top level group that sometimes has no record returned. When there
is no record returned then the report displays a gap. How do I get it to not
display a blank space in my report?
 
You could set the CanShrink property of the text box and the section.

Another idea is to set the Control Source of the text box to something like
this:
=Nz([MyField], "{unspecified}")
and rename the text box (so it has a name different to the field name).
 
Back
Top