Memo Field - Access 03, allow user to insert hard return?

[SBecker]

Is it possible to format memo field to allow user to insert hard return by
hitting enter to leave a space between paragraphs within the field?

 

[Arvin Meyer [MVP]]

Use Ctrl+Enter

 

[John Spencer]

Are you entering directly into the table or into a query? If so, then I don't
believe there is a way to set this up.

If you are using a form and a control linked to to the memo field, you can set
the control's Entry Key Behavior property to "New Line in Field"

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[SBecker]

John,

I'm using a form, and I've tried setting the Enter key behavior to New Line
in Field, but it's telling me that it can't find the macro "New Line in
Field".

Thanks,
Suzanne

 

[Douglas J. Steele]

What are you doing to try to set the behaviour?

What's being suggested is to check the Properties window for the text box in
question. One of the properties for text box controls is named "Enter Key
Behavior" (it's on the Other tab). There are two choices for that property:
Default and New Line in Field. Choose the latter.

If you're trying to do this through code, the name of the property is
EnterKeyBehavior, and you set its property to True.

 

[SBecker]

Perfect! Not sure what I was doing wrong before, because I didn't have the
options of default or New Line in Field in Properties.....

Works great, thanks for your help!

Suzanne