MS Access - how to create query that will output one text field that includes Line Feeds (ASCII code = 10).

Hi Experts,

I'm using Access 2016.

I want to create a query that for each record will output one text field that consists of multiple lines, that is the text field needs to include Line Feeds (ASCII code = 10).

Regards,
Leigh
LVL 1
LeighWardleAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
"Some string" & chr$(10)

a carriage return and line feed would be:

"Some string" & chr$(13) & chr$(10)

"some string" can be a literal string, any text expression, or a text field.

Jim.
0
 
LeighWardleAuthor Commented:
Thanks, Jim, that's great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.