Solved

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

Posted on 2009-04-07
2
1,070 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 92

Accepted Solution

by:
Patrick Matthews earned 500 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

821 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