Address Box, Memo Field Type

[louisa]

I am hoping this will be really easy......
On my db i have an address box which is set to a Memo Type however i want to display the address like so:

123 Made Up Drive
Blah Blah Blah
N23 4TR

However when i press the enter button it will take me to the next field not move me down a row so my addresses end up like: 123 Made Up Drive, Blah Blah Blah, N23 4TR.

Does anyone know how i can change this?

Thank you

 

[DCrake]

Go to the properties of the memo field on your form and look for Keyboard behaviour and change it to Next line in field.

 

[louisa]

Yay worked brilliantly thank you. Under Enter Key Behaviour.