how do I place an actual return key stroke in access record

[Guest]

I made a database and in the middle of a record I want to place a return key
so when I convert to text it has a second line instead of one record on one
single line

 

[Guest]

Hi, edm.

Use a Memo field which permits CR entry.

Sprinks

 

[John Vinson]

I made a database and in the middle of a record I want to place a return key
so when I convert to text it has a second line instead of one record on one
single line

Two ways to do this:

- Press Ctrl-Enter instead of just Enter when you're typing into the
field

- On a Form (which you should be using anyway) you can set the "Enter
Key Behavior" property of the textbox bound to this field to "New Line
in Field". This causes the <Enter> key to put in a new line rather
than moving on to the next control.


John W. Vinson[MVP]

 

[adsl]

I made a database and in the middle of a record I want to place a return
key
so when I convert to text it has a second line instead of one record on
one
single line

 

[adsl]

Hi, edm.

Use a Memo field which permits CR entry.

Sprinks

 

[Guest]

I placed the memo field in center of the record...now what command makes it
acknowledge a return so when I convert it to text it takes the return command?

 

[Guest]

Hi...
Please is there a sample you can give me I tried and did not work...maybe am
doing it wrong

Thanks

 

[John Vinson]

Hi...
Please is there a sample you can give me I tried and did not work...maybe am
doing it wrong

Thanks

I don't know what kind of "sample" you mean.

What exactly did you try? Were you using a Form, or a table datasheet?

My two suggestions, in more detail:

- Start entering text into a Taxtbox on a Form. At the point where you
want a new line, hold down the Ctrl key and press the Enter key.

- OR, open the Form in design view. Select the textbox bound to this
field. View its Properties; find the "Enter Key Behavior" property and
use the dropdown box to change it to "New Line in Field".


John W. Vinson[MVP]