Concat text fields with line break (1 Viewer)

R

rborland

Guest
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

Registered User.
Local time
Today, 14:49
Joined
Feb 3, 2000
Messages
74
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

New member
Local time
Today, 21:49
Joined
Oct 13, 2020
Messages
1
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
 

Isaac

Lifelong Learner
Local time
Today, 07:49
Joined
Mar 14, 2017
Messages
8,738
Random fun fact, it's kind of funny - in an ControlSource expression, you can even type:
Code:
=[Text0] & "
" & [Text2]
............... Where the thing in between the two double quotation marks was me pressing Shift+Enter, literally, while typing in the Expression box.
 

Users who are viewing this thread

Top Bottom