MS Access Shift-Enter

L

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
 
R

Rick Brandt

LD said:
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.
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top