0

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.

4
  • Have you tried shift-enter instead of control-enter? (I'm not sure if this will work in Access.) Aug 15, 2015 at 18:58
  • @aparente001 - I tried shift enter before I had to look up ctrl + enter, or the alternative change default enter behaviour (property field that enables direct carriage returns - which still results in two line breaks when exported to the text file.
    – EngBIRD
    Aug 15, 2015 at 19:52
  • Perhaps this will help? bytes.com/topic/access/answers/… Aug 15, 2015 at 19:58
  • @aparente001 Thanks but I am not trying to concatenate several strings together externally from the memo box, if I insert a char code, it will just show up as text.
    – EngBIRD
    Aug 15, 2015 at 20:14

0

You must log in to answer this question.

Browse other questions tagged .