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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can shrink with sub-report 1
Images not shrinking 1
Can shrink not responding 3
Can Grow/Can Shrink Question.... I think! 1
Remove blank line under combo box 3
Any way to control the size by which a text field on a report grows/shrinks? 1
Fields not shrinking 5
Problem - HUNDREDS of pages blank detail section 4

Back
Top