adding a cariage return to a text field using IF then ELSE statement

[grom71]

Hi,
I've got a formula which looks at a string and displays some text based on this.
i.e IF "rebif 22" in (dbfield) then "please prescribe the dose of rebif as etc etc etc " else (dbfield)

I want to space out the "please prescribe etc etc" in 3 lines of text NOT one long line.
Is there a way of doing this ?

 

[pgtek]

Hi

Try this
IF "rebif 22" in (dbfield) then
"please" & chr(13)&
"prescribe" & chr(13) &
"etc etc etc "
else (dbfield)

cheers






pgtek

 

[bdreed35]

Another option might be to add the formula to your report.
Size the formula to the width you want.
Right Click the field, choose Format Field from the pop up.
Select the option Can Grow under the Common tab.

~Brian

 

[grom71]

Thanks guys that works a treat