MS Access 2007 - Property for text box to allow end-user to hit enter for return, not next

Question

I have a form that is used for data entry, and on one form there is a text box that is used to enter notes. However, if the user hits <ENTER> I need the cursor to stay in that text box and start a new line, but currently it is jumping to the next control (text box).

Is there a simple property setting that would do the trick? Or a VBA method that would accomplish this?

Answer 1

In Ac2003, there is the "Enter Key Behaviour" property, which gets set to "New Line in Field".