CanShrink property messes up other columns

[Carol Grismore]

How do you keep the columns next to the columns you are
growing/shrinking from jumping around on the page?

Example: Name
Address1 Phone
Address2 Fax
City, State Zip

If either Address1 or Address2 is blank, and you set their
CanShrink properties to Yes, the Phone and Fax fields'
print locations move around and make a very unattractive
report.

 

[Marshall Barton]

How do you keep the columns next to the columns you are
growing/shrinking from jumping around on the page?

Example: Name
Address1 Phone
Address2 Fax
City, State Zip

If either Address1 or Address2 is blank, and you set their
CanShrink properties to Yes, the Phone and Fax fields'
print locations move around and make a very unattractive
report.

How are these values being referenced, in separate text
boxes??

Generally, when you have other controls in the same
horizontal band as a can shrink text box, the lower controls
can move up. This leads me to think there is something else
going on.

One possible workaround is to use a single text box for the
name and address. Use an expression something like:

=([Name] + Chr(13) + Chr(10)) & (Address1 + Chr(13) +
Chr(10)) & (Address2 + Chr(13) + Chr(10)) & City & ", " &
State & " " & Zip