Trouble formatting address fields

  • Thread starter Thread starter Gordon
  • Start date Start date
G

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
 
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
 
A row will not shrink if there is anything else on the row (a label
perhaps?)
 
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
 
Back
Top