How do I insert a chr(13) or vbCrLf in a Query expression builder.
Posted on 2009-04-07
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?