Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .