Null Fields in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
Cathy said:
How do I omit a field on a report only when it is a null value?
Click to expand...


What do you mean by "omit"?

If the text box that displays the field is in a "horizontal
band" by itself, the just set both the txt box and its
section's CanShrink property to Yes.

If you mean something else, please explain.
 
We have a report we use often and if the fields are not filled in, we would
like them to not show up. We want the report to print only the fields that
have inputted data.

Thank you,
Cathy
 
Well, I got that much the first time. Did using CanShrink
take care of your question?

If not, you will have to expand on how the controls (not
fields) appear in the report. Are they all next to each
other across the page or are they one above the other down
the page? Do you want them to be blank or do you want the
other controls to move up/left to squeeze out the blank
space? Do they have attached labels? What are their border
property setting?
 
Back
Top