Memo field does not allow <enter> to create linebreak

[adrian.stock22]

Hi All,

I have a database with two memo fields. Both have exactly the same properties in table design view.

One field is called 'notes' and when I want a new line I just have to hit ENTER. Result is as wanted.

The other field is called 'responses' and when I hit ENTER, the cursor jumps to the next field (as if these were a text rather than a memo field). it does not start a fresh line. However, this field has not length restriction; I can copy and paste any number of lines into it. But I must not hit ENTER, and I cannot produce a line break.

As I said above, both fields appear to have exactly the same properties in Design View. Why then do they behave differently?

What's wrong? What have I overlooked?

Thanks for your help.

Adrian

 

[Bosch]

I dont have a solution to your problem..but I have seen what you are talking about..normally in such fields I could use "Control + ENTER" instead of ENTER key..it works as a line break..

 

[WayneRyan]

Adrian,

Tools --> Options --> Keyboard

Then change the "move after enter" to Don't move.

Wayne

 

[adrian.stock22]

Hi Bosch and Wayne,

Thank you for your your suggestions.

Using ctrl-ENTER instead of ENTER worked (produced a line break).

Changing the keyboard options to "Move after enter: Don't move" did NOT have the desired effect. I now have 'don't move', but the result is that the original field is selected in its entirety, i.e. it behaves as if it had just re-entered this field (circular motion: leave field, enter same field).

Adrian

 

[Rickster57]

It would be interesting to see if you create a form using that table and set the Enter Key Behavior to New Line In Field for both memo fields if you get the same thing.

 

[Bat17]

in the properties you should have one "Enter Key Behaviour" make sure it is set too "New Line in Field"

HTH

Peter