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

E

edm

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
 
J

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
Click to expand...

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]
 
A

adsl

edm said:
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
Click to expand...
 
E

edm

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?
 
E

edm

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

Thanks
 
J

John Vinson

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

Thanks
Click to expand...

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]
 
Top