Can Grow/Can Shrink

  • Thread starter Thread starter Patrice
  • Start date Start date
P

Patrice

I have an Access report which I cannot get the can shrink
function to work. The field is a combination of several
shorter fields. The properties of both the field and the
section have "can grow" and "can shrink" marked yes. Any
help would be greatly appreciated.
 
I would check that each of the textboxes has their can
shrink property set to yes. Now if there any labels
related or unrelated within this report band (for instance
in the detail section) these label will not shrink and
therefore these would prevent the detail section from
shrinking. If this is the case you could use IIF
statements such as <IIF([textbox1]is null,"","Label1")>
and/or + operators such as <="label1 "+[textbox1]> to
make the labels invisible is the textbox is null.
Hope this helps.
Fons
 
Back
Top