Trouble formatting address fields

[Gordon]

I have a set of name address details which form a header in a
report. The data source for each row element of the address is
=Trim([fldAddress1]) etc.

The report prints OK but where eg [fldAddress4]) is blank, I get a
blank row, followed by [fldAddress5].

I have checked that the Can Grow & Can Shrink properties of each of
the address controls on the report is set to Yes.

Is there any way to eliminate the blank rows?

Gordon

 

[Wayne-I-M]

Hi Gordon

You could use a concencated unbound text box with the control sourc set like
this. (Change 1stName and Surname to what they are in your table/query)

=([1stName] & " " & [Surname]) & Chr(13)+Chr(10)+[fldAddress1] &
Chr(13)+Chr(10)+[fldAddress2] & Chr(13)+Chr(10)+[fldAddress3] &
Chr(13)+Chr(10)+[fldAddress4] & Chr(13)+Chr(10)+[fldAddress15]

Hope this helps

 

[Arvin Meyer [MVP]]

A row will not shrink if there is anything else on the row (a label
perhaps?)

 

[Gordon]

Hi guys,

No there was nothing else on the row, Arvin, so I guess I'll go with
Wayne's suggestion.

Thanks to both for replying.

Gordon

 

[Paul Shapiro]

Is the Section's CanShrink property set to Yes?