Concatenate form fields and include linefeed

[OssieMac]

Access 2003 Question.

I want to concatenate some table fields into a single text field in a report.
Basic concatenation works OK but I cannot get linefeeds to work. Every way I
try I just get square boxes and no line feeds.

Will very much appreciate it if I can get either confirmation that it can't
be done or preferrably how to achieve.

 

[OssieMac]

I feel foolish when I have posted a question and the answer comes to me
later. Just had to get the code the correct way around. Chr(13) & Chr(10). I
had them reversed.

 

[Linq Adams via AccessMonster.com]

I find it easier to remember the VBA constant, vbNewLine

"First Line" & vbNewLine & "Second Line"

yields

First Line
Second Line

 

[OssieMac]

That works fine in VBA and I use it myself but when concatenating table
fields into a form or report textbox it is not recognized.