Chr$(13) & Chr$(10) & Chr$(10), Access 2002 report

[jdph40]

I am trying to enter text to look like paragraphs in a text box on a
report, making it look like a memo. I enter (Chr$(13) & Chr$(10) &
Chr$(10)) to insert a carriage return and 2 line breaks, but a small
black square prints on the report. If I enter Chr$(10) once, the
square doesn't print. Can you only have one line break?

TIA,
JD

[fredg]

On 19 Jan 2005 14:15:26 -0800, jd****@yahoo.com wrote:

I am trying to enter text to look like paragraphs in a text box on a
report, making it look like a memo. I enter (Chr$(13) & Chr$(10) &
Chr$(10)) to insert a carriage return and 2 line breaks, but a small
black square prints on the report. If I enter Chr$(10) once, the
square doesn't print. Can you only have one line break?

TIA,
JD

In access, you need both chr(13) & chr(10) for each line space wanted.
=[FieldName] & chr(13) & chr(10 & chr(13) & chr(10) & "New Text"

If you are using VBA in a code window, you can, in addition to the
above, use vbNewLine or vbCrLf for each new line.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.