Can a report skip a blank field while printing?

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

Guest

I am generating a report in Access. I would like the report to skip a blank
field and go to the next field without printing a blank line. How do I do
this?
 
1. Open your report in design view.

2. Right-click the text box, and choose Properties.

3. Set the CanShrink property to Yes.

Access will set the CanShrink property of the Detail section for you.

Note that this does not work if you have anything else overlapping the
control vertically. That includes the attached label of the control. To
suppress the label also:
4. Right-click the label, and choose Change To | Text box.

5. Set the CanShrink property of this text box also.

6. Set its Control Source to an expression that ensures its value is Null if
the other field has no value. For example, if the main text box is called
Text1, use:
=IIf([Text1] Is Null, Null, "Whatever the label should be here.")
 
"blanks" are never printed ie: they don't use either toner or ink. Perhaps
you could explain what you mean by "skip" and "go to the next field". A few
typed in examples work wonders for questions like this.
 
Back
Top