I don't want null values to leave space in my report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report that lists comments from a survey, however when the
comments field was left blank, a blank line shows up in the report. If there
is more than one consecutive empty fields, there is a large gap of white
space in the report. How can I tell the report to not include the field if
the record shows a null value in the field?
 
Set the CAN SHRINK Property to TRUE. As long as there are no other controls
to the left or right, it will not leave any blank space.
 
It would have saved someone's valuable time if you would have stated what
you had tried in your first post.

What does your text box look like if you set the border to a color? Does the
text box still appear? If so, is it possible the value in the field isn't
actually null?
 
I had the exact same problem.
On your report, right click the square in the upper left corner, select
properties, then on the data tab, in the filter box, type this: [Name of
field or query]<>Null
then select yes on the box below.

What this does is keeps the report from displaying Nulls or blanks where you
don't want them by filtering them from being even considered by the report.
Now I have a bunch of sub reports on me report, but hopefully it will work
the same for you
-Bob
 
Back
Top