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

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?
cebaker75Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Patrick MatthewsConnect With a Mentor Commented:
Use Chr(13) *and* Chr(10)...

SELECT Field1 & Chr(13) & Chr(10) & Field2
From SomeTable
0
 
cebaker75Author Commented:
Thanks!  Works perfect!
0
All Courses

From novice to tech pro — start learning today.