Concatenate form fields and include linefeed

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.

--
Regards,

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.

--
Regards,

OssieMac


"OssieMac" wrote:


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.

--
Regards,

OssieMac

I find it easier to remember the VBA constant, vbNewLine

"First Line" & vbNewLine & "Second Line"

yields

First Line
Second Line

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

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.

--
Regards,

OssieMac


"Linq Adams via AccessMonster.com" wrote:

I find it easier to remember the VBA constant, vbNewLine

"First Line" & vbNewLine & "Second Line"

yields

First Line
Second Line

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

.