can grow/shrink problem in report

[dm1]

Hi, Can anyone shed any light on why the can grow/shrink property in a report doesn't always work?<br><br>Can give good example.&nbsp;&nbsp;Take 4 address fields, each using the dlookup function to display data - they grow/shrink just fine.&nbsp;&nbsp;One other field (the country in address section) uses the Iff function to test for UK or overseas - that doesn't grow/shrink.&nbsp;&nbsp;OK, UK addresses show fine because the country is excluded, but overseas addresses leave spaces if say the state or zip code is missing.<br><br>Any solutions you guys and gals might have would be appreciated <br><br>Cheers, Jon.<br>

 

[DougP]

Does it have a TRIM stement in it?<br><br>=Trim([MyCountry]) <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

Doug, I'm not sure why i would need the Trim function.&nbsp;&nbsp;My fields, one below each other etc, are shrinking vertically, with the exception of the Country field - that's the one that stays fixed regardless of the can grow/shrink setting.<br><br>Any other ideas?<br><br>Regards, Jon.

 

[Guest_imported]

Have now resolved the can grow/shrink problem.&nbsp;&nbsp;Seems to be adjacent controls were interfering with the positioning.&nbsp;&nbsp;Relocate those controls and grow/shrink works fine.&nbsp;&nbsp;However, it meant that nothing useful could be placed to the right of the address fields.<br><br>Proper solution:&nbsp;&nbsp;Place address fields in subreport, set grow/shrink, and embed in main report.&nbsp;&nbsp;All works just great and can also have other fields to righthand side of address.<br><br>Cheers, Jon.