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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report/subreport display 3
Report Returned Record Count 2
How do I eliminate gaps between bordered lines in Access reports? 1
repeating subreport header on report 0
leave out null fields 1
Record count in report w/o records 9
gap in my report 3
Access Access Record Order 0

Back
Top