"Can shrink" = Yes, not working - Access 2003

[dawnd3]

Hi everyone. I am building a report that has chunks of data layed out vertically, like so:

FirstName LastName
Title
Address
City, State Zip

The title field is often blank so to avoid blanks in the report, I scrunched up the title field and set the can grow property to yes as well as the can grow for the detail section. This isn't working. So I thought, maybe Access thinks there is zero length string in the field. So I tested it out and found that the blank fields are indeed NULL and not zero length string. So, what else can it be? This usually works but occasionally I have this issue where it doesn't.

Thanks,

Dawn

 

[Remou]

Are the controls touching one another? I have found that unless the top line of the lower control is concurrent with the bottom line of the upper control, the controls do not shrink properly. An alternative is to create a control that concatenates the relevant address fields.