Text Box in a Report

[Guest]

This is my control source for a text box:

=([Company]) & Chr(13) & Chr(10) & ([BizShipAddr]) & Chr(13) & Chr(10) &
Trim([BizshipCity]) & ", " & ([Bizshipstate]) & " " & ([BizshipZip])

Programmically is it possible, if there is NO company name, not to put a
blank line there? I have another text box above it with Attn: ContactName
and if there is no company name, there is a blank line between that & the
street address. I kept them in seperate boxes as Attn line is bold red.

Thanks
Curtis

 

[fredg]

This is my control source for a text box:

=([Company]) & Chr(13) & Chr(10) & ([BizShipAddr]) & Chr(13) & Chr(10) &
Trim([BizshipCity]) & ", " & ([Bizshipstate]) & " " & ([BizshipZip])

Programmically is it possible, if there is NO company name, not to put a
blank line there? I have another text box above it with Attn: ContactName
and if there is no company name, there is a blank line between that & the
street address. I kept them in seperate boxes as Attn line is bold red.

Thanks
Curtis

Why do you have all those extra sets of parenthesis?

Use the + instead of the & in the first part of the expression, and
place the parenthesis as I have them.

= ([Company] + (Chr(13) & Chr(10))) & [BizShipAddr] & Chr(13) &
Chr(10) & Trim([BizshipCity]) & ", " & [Bizshipstate] & " " &
[BizshipZip]