Removing blank lines from reports

[aquarius9000]

I need to suppress blank lines in the address fields for example: I have a company field but if the client does not have a company I don't want to have a blank line on the report.

I did a search before I posted this and have not found anything helpful.

 

[Remou]

You can build your own text box, for example:

[tt]=[company] + vbCrLf & [adr1] + vbCrLf & [adr2][/tt]

 

[NeilT123]

I use the following. It may be a bit longwinded but it works for me

=IIf(nz(Trim([AccountName]),"")<>"",[AccountName] & Chr(13) & Chr(10)) & 
IIf(nz(Trim([Address1]),"")<>"",[Address1] & Chr(13) & Chr(10)) & 
IIf(nz(Trim([Address2]),"")<>"",[Address2] & Chr(13) & Chr(10)) & 
IIf(nz(Trim([City]),"")<>"",[City] & Chr(13) & Chr(10)) & 
IIf(nz(Trim([County]),"")<>"",[County] & Chr(13) & Chr(10)) & 
[PostCode]