MS Access Shift-Enter

[LD]

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

 

[Rick Brandt]

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.

 

[John W. Vinson]

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