By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,953 Members | 1,438 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,953 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.