Eliminating blank lines in detail section

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

Guest

I am generating a report with most of the data on one line - e.g., name, address, home phone number, etc. Because of space limitations on a line I am placing the cell phone number field (along with a label) on a second line below the home phone number. Is there a way to eliminate the second line if the cell phone number field is null?
 
Set the text box bound to the cell phone to Can Shrink: Yes
Change the label to a text box that Can Shrink and set its control source
to:
="Cell Number " + [CellPhoneField]
Make the "label" text box to wide enough just to display just "Cell Number"

--
Duane Hookom
MS Access MVP


jmark said:
I am generating a report with most of the data on one line - e.g., name,
Click to expand...
address, home phone number, etc. Because of space limitations on a line I
am placing the cell phone number field (along with a label) on a second line
below the home phone number. Is there a way to eliminate the second line if
the cell phone number field is null?
 
That worked fine as far as eliminating the text displayed on the line, but is there also a way to eliminate the linefeed?
 
Are you wishing to eliminate a horizontal band of blank space on your
report? If so, are your controls set to Can Shrink? Are there any controls
to the left or right of the controls you expect to shrink? You can
temporarily set the border of a text box to a color to see if the controls
are shrinking or not.

--
Duane Hookom
MS Access MVP


jmark said:
That worked fine as far as eliminating the text displayed on the
Click to expand...
line, but is there also a way to eliminate the linefeed?
 
Yes, I would like to eliminate the blank band if the Cell Phone number is null. In other words, I would like the next line to appear directly under the "current" line if there is no Cell Phone number
I tried what you suggested with a color border and saw a blank space when there is no Cell Phone number, and the "label" and phone number in a colored border when there was a Cell Phone number. Is it possible that by defining a second line in the detail section that there is no way to eliminate it?
 
jmark said:
Yes, I would like to eliminate the blank band if the Cell Phone number is null. In other words, I would like the next line to appear directly under the "current" line if there is no Cell Phone number.
I tried what you suggested with a color border and saw a blank space when there is no Cell Phone number, and the "label" and phone number in a colored border when there was a Cell Phone number. Is it possible that by defining a second line in the detail section that there is no way to eliminate it?
Click to expand...


You also have to set the section's CanShrink to Yes.
 
Back
Top