468,733 Members | 2,211 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,733 developers. It's quick & easy.

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

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

Nov 13 '05 #1
1 8028
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Eddie B. | last post: by
6 posts views Thread by C L Humphreys | last post: by
2 posts views Thread by lauren quantrell | last post: by
10 posts views Thread by Dan Nash | last post: by
1 post views Thread by Felix | last post: by
5 posts views Thread by Computer Guru | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.