Wrapping text?

[Jeff Heikkinen]

How do I get the text to wrap in my report in a text box whose control
source is an expression? It wraps just fine for me in text boxes whose
control source is simply a field name, but I have two fields where there
is an expression (an IIf statement to be precise) instead, and in both
of them the text just continues off the side of the page, and thus
doesn't print, rather than wrapping around and starting a new line like
it does in some of the other text boxes.

 

[Jeff Heikkinen]

Jeff Heikkinen, worshipped by llamas the world over, wrote...

How do I get the text to wrap in my report in a text box whose control
source is an expression? It wraps just fine for me in text boxes whose
control source is simply a field name, but I have two fields where there
is an expression (an IIf statement to be precise) instead, and in both
of them the text just continues off the side of the page, and thus
doesn't print, rather than wrapping around and starting a new line like
it does in some of the other text boxes.

FOund out in another newsgroup that eliminating the @ symbol that is
automatically in the Format property fixes this.