Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I insert a chr(13) or vbCrLf in a Query expression builder.

Posted on 2009-04-07
2
Medium Priority
?
1,629 Views
Last Modified: 2013-11-27
I have a query that contains 3 fields with varying strings.  I added an expression to combine the values of all three fields, seperated by a carriage return.  Problem is when I use chr(13) or chr(10) I get a box instead of the carriage return/line feed.  When I try vbCrLf, the query prompts for user input.  Is there any way to accomplish this?
0
Comment
Question by:cebaker75
2 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 24090161
Use Chr(13) *and* Chr(10)...

SELECT Field1 & Chr(13) & Chr(10) & Field2
From SomeTable
0
 

Author Closing Comment

by:cebaker75
ID: 31567636
Thanks!  Works perfect!
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question