Formula for non-printing lines in Access Report

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

Guest

Can anyone give me the formula that ensures that in an address list, where
some addresses have more lines than others, the blank lines are not printed?
I would be so grateful for this.
 
Forsyth

Not code. Open the report in design mode. Select the control that holds
the (potentially "empty") data. Click on the Properties toolbar button.
Mark the CanGrow and CanShrink properties as "Yes". Now do the same for the
entire section in which the control is located.

If you have more than one control which may potentially be empty, repeat.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes it does help. From where we are sitting, we don't see any problems or
symptoms with what was proposed ;-)
 
If you could be more specific, we would be able to provide more specific
suggestions.

Is there any chance your report definition has controls located directly to
the right of the control you wish to have shrink? If so, it will "hold
open" the control that would otherwise be growing/shrinking.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Maybe I am setting the page up incorrectly. I form a Query and then open
Report in Design view, close Header and Footer so am just left with Detail
section, open Field list and drag it to the desired space. However I then
have to Delete the Label box leaving me just with the "unbound?" text box. I
check Properties for each field and make sure Can grow and Can shrink are at
Yes. I then check Properties for Detail in the same way. After that I open
Layout view and behold there are still gaps in the address lines. I am a
self-taught grandmother and obviously doing something the wrong way! Best
wishes.
 
Try use the Print Preview rather than the Layout Preview. As Jeff mentioned
any controls with values to the left or right of a "can shrink" control will
cause the report to not shrink.

To trouble-shoot, temporarily display the border of the controls so you can
see what's happening.

BTW: I'm a self-taught grandpa.
 
Thanks. I have tried with only one column of fields and it still does not
shrink. If in Design I click on a field it brings up the control border (I
think that is what you mean) but it does not show me anything else. Using
Print layout makes no difference - they both look the same. Baffled.
 
I would like you to click on a text box that you want to shrink. Make sure
its Can Shrink property is Yes and then set its
Border Style: Solid
Border Color: 255
Then print preview the report to see if the text box is visible.

What is the control source of the text box? Are you sure the value in the
text box is Null and not just a zero-length-string?
 
Back
Top