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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top