Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to use the CanShrink property in a report in Access 2007 so that if the mailingAddress2 field from my query is null or blank it will collapse the Address 2 field and move the mailingCity, mailingState fields up.

All the fields shown are text boxes.

Mailing Address Labels with the field I want to shrink

I read about the CanShrink property and I don't know what else I need to try collapse the field.

share|improve this question
There's something here ( that says you have to set the "CanShrink property for the text box AND the section it's in to YES" what's the section detail? – leeand00 Dec 21 '12 at 14:51
Concatenating a space may prevent the field from shrinking. – JeffO Jan 7 '13 at 19:51

You can alter your data source (query) to add a new field or just add a text box and apply to the control source property.

Query Field: MailingAddres1and2: IIf(IsNull(MailingAddress1), MailingAddress, MailingAddress & Chr(10) & MailingAddress)

or Control Source of a Text box: =IIf(IsNull(MailingAddress1), MailingAddress, MailingAddress & Chr(10) & MailingAddress)

Chr(10) will insert a carriage return.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.