Concat text fields with line break

[rborland]

I'd like to concatinate several text fields that are in the query for my report and present the resulting string in a single text box on the report. I'd also like to provide line feed breaks after each field's value so that the composite field would "grow" with the concatinated values.

I'm using Access 97. I've tried chr(13)'s in between values - no cigar.

 

[Axis]

Access wants a carriage return AND a line feed to create line breaks. Try
=[First Field] & Chr(13) & Chr(10) & [Second Field] etc.

 

[saeful.amron]

Access wants a carriage return AND a line feed to create line breaks. Try
=[First Field] & Chr(13) & Chr(10) & [Second Field] etc.

it works, thank you very much

 

[theDBguy]

it works, thank you very much

Hi. Welcome to AWF!

 

[Isaac]

Random fun fact, it's kind of funny - in an ControlSource expression, you can even type:

=[Text0] & "
" & [Text2]

............... Where the thing in between the two double quotation marks was me pressing Shift+Enter, literally, while typing in the Expression box.