concetenate three fields into one text box in my report

F

FA

Hi Freinds,
I need to concetenate three fields into one text box in my report. I
dont know how its possible, if some can help me, i would really
appreciate it.
My field names are

SMRY
RSK_DESC
RCMN
I want the data in these field to come in one textbox on the report.

Please help me

Thanks
Moe
 
R

Rick B

=[SMRY] & [RSK_DESC] & [RCMN]

or...

=[SMRY] & " " & [RSK_DESC] & " " & [RCMN]



Just put that in your unbound text box.
 
R

Rick B

Something like...

= "This is line 1." & chr(13) & chr(10) & "This is line 2."

= "This is line 1." & vbcrlf & "This is line 2."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Grow and Can Shrink Issue in MS Access Report 1
Displaying data in one text box in MS Access Report 1
Report generated from text box fields 2
Filtering subreports on main report 0
Representing Alphabet instead of Number in MS Access Report Column 5
Crosstab report - handling Null fields 4
MS Access Query Issue 17
How to wrap word in a text box in a report 2

Top