MS Access Shift-Enter

I work with MS Access version 2000.
I would like to use Shift-Enter in a Macro as a part of SetValue to create
new lines in a memo-type textbox.
I tried by adding chr$(10) in the text, but it did not create the new line.
It printed a "little box" in the text line.
I would highly appreciate it if someone can help.
LD

LD wrote:
I work with MS Access version 2000.
I would like to use Shift-Enter in a Macro as a part of SetValue to
create new lines in a memo-type textbox.
I tried by adding chr$(10) in the text, but it did not create the new
line. It printed a "little box" in the text line.
I would highly appreciate it if someone can help.
LD

You need both Chr(13) & Chr(10) and they must be in that order.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Fri, 22 Aug 2008 17:57:01 -0700, LD wrote:

I work with MS Access version 2000.
I would like to use Shift-Enter in a Macro as a part of SetValue to create
new lines in a memo-type textbox.
I tried by adding chr$(10) in the text, but it did not create the new line.
It printed a "little box" in the text line.
I would highly appreciate it if someone can help.
LD

You can use Ctrl-Enter and Access will insert a CR-LF pair (Chr(13) followed
by Chr(10)) all by itself without code, and without interfering with the
builtin function of Shift-Enter to save a record; or you can set the "Enter
Key Behavior" property of the textbox bound to the memo field to "New Line In
Field".
--

John W. Vinson [MVP]