How to put Carrage Return in Memo Field?

[Will]

Access won't let me put a carrage return in the Memo Field. (Office 2003
version)

Seems like I could hit enter and get a new line in my older version of
Access.

How can I get Access 2003 to allow me to press Enter and start a new line in
the Memo field?

thanks for any help.

 

[Arvin Meyer]

In the property sheet for the text box which holds the memo field, go to the
other tab. Click on Enter Key Behavior and change it to New Line in Field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

You can use CRTL+Enter.

In the property sheet for the text box which holds the memo field, go to the
other tab. Click on Enter Key Behavior and change it to New Line in Field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike Labosh]

Dim r As Integer

r = Int(Rnd(Len([Field]) + .5)
[Field] = Left$([Field], r - 1) + vbCrLf + Right$([Field], Len([Field]) - 1)

}

--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]

 

[peregenem]

Access won't let me put a carrage return in the Memo Field.

CREATE TABLE Test (test_memo MEMO NOT NULL)
INSERT INTO Test VALUES (CHR$(10))
SELECT test_memo, LEN(test_memo) AS memo_length FROM Test