[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Force carriage return line feeds in an access query

I have a query expression that looks like this
Everywhere I start a new line I need to force a carriage return line feed because the report is not picking it up.

What do I need to do to fix this?  Thanks

Expression Below
******
UW_Complete_Block: [UW_Name_Block] & "
" & [Underwriter_Address] & "
" & [Underwriter_City] & ", " & [Underwriter_State] & "  " & [Underwriter_Zip] & "
" & [UW Phone_Block] & "
" & [UW_EMail_Block]
0
charming
Asked:
charming
1 Solution
 
Patrick MatthewsCommented:
UW_Complete_Block: [UW_Name_Block] & Chr(13) & Chr(10) & [Underwriter_Address] & Chr(13) & Chr(10) & [Underwriter_City] & ", " & [Underwriter_State] & "  " & [Underwriter_Zip] & Chr(13) & Chr(10) & [UW Phone_Block] & Chr(13) & Chr(10) & [UW_EMail_Block]
0
 
charmingAuthor Commented:
Outstanding as always!!!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now