Concatenate form fields and include linefeed

  • Thread starter Thread starter OssieMac
  • Start date Start date
O

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.
 
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.
 
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.
 
Back
Top