Carriage return in label?

[Dixie]

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

[Rick Brandt]

"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.

[fredg]

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

[David W. Fenton]

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

[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.

[Bruce Rusk]

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