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

Carriage return in label?

P: n/a
Can I program a label with a carriage return to put the 2nd part of the
label on a new line. The only way I can see of doing this is to convert the
label to a text box, then use chr$(13).

dixie
Nov 18 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Dixie" <di***@dogmail.com> wrote in message
news:43******@duster.adelaide.on.net...
Can I program a label with a carriage return to put the 2nd part of the
label on a new line. The only way I can see of doing this is to convert
the label to a text box, then use chr$(13).


Make the label taller and press <Shift Enter> to insert a Cr.
Nov 18 '05 #2

P: n/a
On Fri, 18 Nov 2005 12:33:45 +1100, Dixie wrote:
Can I program a label with a carriage return to put the 2nd part of the
label on a new line. The only way I can see of doing this is to convert the
label to a text box, then use chr$(13).

dixie


Chr(13) won't help you any. :-(
In Access you must use chr(13) & chr(10) in that order.
="Line one." & chr(13) & chr(10) & "Line two.

In a label caption, use the Shift+ Enter keys.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 18 '05 #3

P: n/a
fredg <fg******@example.invalid> wrote in
news:1l******************************@40tude.net:
On Fri, 18 Nov 2005 12:33:45 +1100, Dixie wrote:
Can I program a label with a carriage return to put the 2nd part
of the label on a new line. The only way I can see of doing this
is to convert the label to a text box, then use chr$(13).

dixie


Chr(13) won't help you any. :-(
In Access you must use chr(13) & chr(10) in that order.
="Line one." & chr(13) & chr(10) & "Line two.

In a label caption, use the Shift+ Enter keys.


Ctrl-Enter does the same thing.

I had never even known about Shift-Enter.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 18 '05 #4

P: n/a
Jay

Dixie wrote:
Can I program a label with a carriage return to put the 2nd part of the
label on a new line. The only way I can see of doing this is to convert the
label to a text box, then use chr$(13).

dixie


You can accomplish this by pressing Return while holding down the Shift
button. If you wish to do this through code, then it would the "line
feed" character which I believe is (without looking it up) char# 10
instead of the "carriage return" character # 13.

Nov 18 '05 #5

P: n/a
You can accomplish this by pressing Return while holding down the Shift
button. If you wish to do this through code, then it would the "line
feed" character which I believe is (without looking it up) char# 10
instead of the "carriage return" character # 13.


Or the vbNewLine and vbCrLf constants
Nov 18 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.