canshrink trouble

  • Thread starter Thread starter bobby
  • Start date Start date
B

bobby

any help appreciated as i am a novice with access. i have
a report with the following field layout:
name Lead1
type Lead2
Lead3
Lead4
Description
i have the fields set to cangrow=yes and canshrink=yes.
my problem is that even if the fields are null there is
still a gap between the information (the fields don't
shrink). is there any way this can be done? thanks in
advance.
 
Bobby,

Check that the Can Shrink property of the report Section itself is set
to Yes.
 
it is set to yes.
-----Original Message-----
Bobby,

Check that the Can Shrink property of the report Section itself is set
to Yes.

--
Steve Schapel, Microsoft Access MVP



.
Click to expand...
 
Bobby,

Ok, next quetions :-)...
1. Are there any other controls, for example label or line or
rectangle, on the same horizontal level as the textbox you are expecting
to "shrink"?
2. Are you sure the field is Null, as distinct from ""?
 
thanks for getting back. there are other contols on the
same horizontal level but they do not touch the controls i
am trying to shrink. i believe the field is set to null -
how can i check? many thanks.
 
Bobby,

Unless the controls on the same horizontal level are also null textboxes
also with their CanShrink = Yes, you can't do what you are trying to do.
Your textbox can shrink, but if something beside it can't shrink, then
that overall "strip" of the report can't shrink. Whether or not the
other controls are touching the control you are trying to shrink, is
irrelevant. Hope that makes sense.
 
Bobby,

What are the controls alogside the textbox which are causing this
problem? If it's a label, you can get around it by using a textbox,
formatted to look like a label, also with Can Shrink, and its Control
Source set to the equivalent of...
=IIf(IsNull([NameOfField]),Null,"YourLabelText")
 
Back
Top