Unanswered: newLine in a memo field and print error
The problem is that I want to write "newLines" in the field of the table I created to print the report. So, Chr(13) doesn't work, vbNewLine closes the field, I mean when I insert a vbNewLine in the field and I print, it finishes printing when it finds a vbNewLine.
Moreover, It is giving this error:
"The report name 'Print' you entered is mispelled or refers to a report that isn't open or doesn't exist"
I'm not sure this will help, but I had a similar problem with memo fields and queries. The string in the query was built up from several fields in different tables and I needed to put a line break inbetween some of the fields.
The solution that worked for me was to set up a function - I called it get_CR() - and call that from the query.
Thank you, your combination of Chr does a right "newLine". But it stops to print after 3 lines of text. So I think the problem is the error that it gives me about "The report name 'Print' you entered is mispelled or refers to a report that isn't open or doesn't exist"
And the combination of Chr takes less time than the vbNewLine, so the printer can print one line more before the error occurs.