I am preparing a database with many different types of fields. One, a memo field is best organized with line breaks. When I type the lines and use the appropriate Ctrl + Enter
to force a line break, all looks good.
Line 1
Line 2
Line 3
Then I have a script that connects to a query in the database which concatenates a large string of text and memo fields together and saves the complete column into a text file. Unfortunately this is filled with extra line breaks i.e.
Line 1
Line 2
Line 3
All these extra lines are not intended or desired.
So to me it looks like this line break is not doing what I thought, but since this special character works behind the scene, I am not quite sure what it is doing and how I can get a single line break in both instances.