Fields In Text Box

building reports desktopintelligence
1

Hiya,

I need to create a mail merge stye report, that will include fields.

How can I create a large text box and include fields into the body of the text.

Like this " Dear <<Field_Name>>, how are you ?"

richardcook (BOB member since 2004-07-22)

2

Try:

= "Dear " &amp; <Field_Name> &amp; " welcome to BOB"

Andreas :de: (BOB member since 2002-06-20)

3

Ah an “&” - who would have thought !

Thanks very much

richardcook (BOB member since 2004-07-22)

4

use & to concatenate and Char(10) for line break.

for example : in the big text box put the below code
="1 st line " & & Char(10) & “2nd line”

where is the any report variable

JaiGupta (BOB member since 2002-09-12)